keep two forms in sync

[hnunez4399]

I have a question what do I need to do if I have a sub form I want to add to to a form that is already a subform in order to keep the records in sync.

thanks,
Hector

 

[redwoodly]

straight from Access HELP:

Drag the form, table, or query from the Database window to the subform.
Microsoft Access creates another subform inside the first subform and creates a form for the subform.

 

[ptpaton]

Just to add to redwoodly's reply, make sure that you have common fields between the master form and the first child, and then again from the first child to the second. Then, make sure that you've designated all of your master/child fields correctly...otherwise all of your forms will be out of whack! This usually needs to be checked at the table level, making sure that there's a unique fiend that's traceable all the way from your master or upper level tables down to your lower ones.

-Patrick

Nine times out of ten, the simplest solution is the best one.