Most queries are editable/updateable which leads me to supect something is mismatched in your basic database design.
Phil is quite right in that we have too little information about your database structure.
Normalization is normally your best friend as well as a properly designed database.
Please read thru
Database Normalization and Table Structures
From your last post just one more question:
Are you after something along these lines
Selecting the record in the first subform (parent)
Brings up the related records from the second table
Selecting a record in the second subform (child)
Brings up the related records in the third table (grandchild)
The way I've designed this requires no VBA or Macro scripting to run.
NOTE: Because this is an
example on how to use subforms and table relationships; I've used separate tables for parents, children, and grandchildren. This is not the way I would normally design a genealogy type database - Allen Browne actually has a design I would use for such at database.
> I have a variation on the theme
Form_A is unbound
Three subform-controls on Form_A: sfc_A, sfc_B sfc_C
Two textbox controls (like the one shown above) one that takes the required information from sfc_A that sfc_B uses to link the two and the second takes the information from sfc_B to link sfc_B to sfc_C
Same concept as the image; however, sfc_A, sfc_B, and sfc_C are in datasheet view and it's a bit more obvious to some of my users how to navigate the records.
Form_A serves as just the container for the subforms and the requisite controls. It also has the company logo and some short/simple instructions on how to use the form.