Linking subforms in a tab control

[Maria J]

Hi,
I have a form with a 6-page tab control, each page containing a subform. The subforms have between 10 to 15 fields each. The subforms were designed from tables which share a 1 to 1 relationship, all with the same key (Client ID).
I want to link these subforms, so that Access recognizes that they all belong to the same client, and have a single navigation button for ALL the tabs above the tab control. How do I do this?
I chose this design due to the amount of tables in which I have to input information (I figured a single form with several tabs would make it easier).
Please bear in mind, that I'm a beginner with Visual Basic, but eager to learn.
Thank you in advance.

 

[HiTechCoach]

There should be no VBA required to do this. You do need to set the master and child linking field properties for the sub form controls. Access will do the rest.

 

[CEH]

I think you should first look at your relationship structure... It's hard to believe with that many fields your tables have a 1 to 1 relationship. Usually... A subform is the "Many" side of a "one to many" relationship.