Multiple tables for a tabbed form

Is it possible to have multiple tables for use on a tabbed form?  I want each tab to have a separate table as it's record source.  Each table would have a common number key field for linking/relationships.
SteveL13Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kelvin SparksConnect With a Mentor Commented:
I guess that the common key is also in a table. Bind your form to that table, add the tabbed container. Create a form for each table, and add them as subforms onto the respective tabs - setting the parent/child properties accordingly.

Kelvin
0
 
crystal (strive4peace) - Microsoft MVP, AccessConnect With a Mentor Remote Training and ProgrammingCommented:
as Kelvin said, you will need to make a form for each table. The Tab Control is just a container for organizing; the tab pages don't have a RecordSource.  Once the forms are created, you can drag them from the navigation pane onto the form in design view.

You can put multiple forms on each tab.

for synchronizing, fill LinkMasterFields and LinkChildFields for each form that is used as a subform.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.