Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 83
  • Last Modified:

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.
0
SteveL13
Asked:
SteveL13
2 Solutions
 
Kelvin SparksCommented:
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, AccessRemote 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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now