Jul 16 2010, 09:40 AM
HI Guys, dont we just love short dead lines and last minute changes.
I have a QA CA database that has a master table with linked sub tables for costs, corrective actions etc
I have a master form with a sub form that has on each row a summary of each QA issue.
I then have a tabbed control with subforms in for each of the linked tables, these are in single form view
what i need to do is when a row on the top datasheet subform is clicked on or selected, i need all the sub forms in the tabbed contol to reference that issue.
I am pretty sure i am missing something simple on how to reference a field on the specific row, but it has gone.
Any one got any ideas of point me in the right direction
Jul 16 2010, 09:53 AM
The way mainform/subform is designed to work uses the subform CONTROL on the main form. That control has a pair of properties relating to the "parent" and "child" fields that Access is supposed to use to keep the record shown on the main form sync'd with the record(s) shown on the subform(s).
Is this how you have your forms set up?
Jul 16 2010, 10:21 AM
Hi the problem is that there is no records on the main form, the record are in a subform datasheet view. What i need is as you select or scroll through the records in the datasheet view this changes the reference to the other subforms in the seperate tab controls
hope that make sence
Jul 16 2010, 10:50 AM
What Jeff is referring to is forms and and subforms relate just as Primary and Child tables relate to each other. If you place your sumbform datasheet view containing the records to select from on the Main form instead, then for the other subforms on the Main form, set the Master/Child links appropriately, then the other subforms would automatically be in sync with the Main form upon selecting a different record.
Jul 16 2010, 10:59 AM
Thanks for the information, is there no way to do it subform to subform. Also so it would take which ever record the pointer on the right is pointing too as the master is this correct?
Jul 16 2010, 12:48 PM
" ... pointer ... on the right ..."?
We aren't there. We can't see your db. Can you describe a bit more specifically what's happening?
Jul 16 2010, 02:48 PM
when you have a datasheet from and list the records there is a black point on the small coloum on the left with is pointing to the selected row.
Jul 16 2010, 06:34 PM
No, that pointer is for the current record that has focus - nothing more. For sure, you could finagle something so that if the record changes, you requery the other subforms accordingly; however, that is not using good database/ui design, nor taking advantages of the features MS Access gives you to access and present the data easily. Use the Main Form to subform Parent/Child links, and you will be amazed how easy it is. If you are not there yet, like Jeff suggested, post your MDB (in a WinZIP file) and give us some background of your data relationships.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here