Linking subforms in 6 tabs within a form

[Maria J]

Hi,
I have a form with a tabs control of 6 tabs. Each tab has a subform of 10-12 fields. These subforms depend on tables which are linked by a 1-to-1 relationship. Client ID is the shared key of all these tables.
I want to have a single record selector for all the tabs, and not for each tab which is what I have now (additionally I have the record selector for the entire form).
How can I tell Access to recognize that the subform on each tab refers to the same client (all subforms have the same client ID).
I'm learning Visual Basic.
Thank you in advance.

 

[Simon_MT]

Your Main form should be the Client from Client Table. From there you can complete the Master / Child with the relevant ClientID.

Simon

 

[Maria J]

Simon,
I don't where the tabs fit in. I know how to insert a subform within a form, but what the tabs? Could you explain further or give some more guidelines

 

[Simon_MT]

Maria,

Basically, you need to create the Tab Control and then go into each of the 6 tabs and place the subform onto the tab. Some versions of Access the position and size of the SubForm need to be adjusted.

Simon

 

[Maria J]

Thanks Simon. I have done so and it works fine.