i got multiple subforms but i want them to be syncronized. if i open one subform with the id autonumber 10 i want my other subforms to pull up with the id autonumber 10. i've already made one to many relationship from the main form to the other subforms. how can i get all of these other forms to populate the same auto number and to be able to pull them up in the same time while i access the form? thank you.

Just make sure that your Parent and Child Link are the same primary id field for each subform.

I am having the same problem. I get some of the subforms on a form to work just fine, as I move record to record, the subforms follow along. Two of my subforms, however, I cannot seem to get working.

I have looked at the joins, and have deleted and remade them thinking that I had something wrong, but still no avail.

Any suggestions on where to look to track down why some are working but not others?

Tearing what little hair remains out,
Arthur

Your main primary id is the link here. Each one of your subforms must have the Primary ID wihin them. If you are working off of multiple tables, each table must also have a field name and type of your primary ID. Check over your two subforms and the corresponding tables. Are your 2 subforms showing the fields as empty or are the subforms not showing at all?