Different tabs/different tables

P

Prince

If I have 2 tabs on a form, how do I get each tab to have different
information from different tables. Example: I'm creating a databade where the
first tab is general client information and the second tab is important dates
to remember for each client. How would you go about designing it or
programming it so I can haver the form open and view 1 clients general
information and click on their important dates and then switch clients and
view their general information and important dates?
 
D

Douglas J. Steele

Create two forms, one for each table.

Use those forms as subforms on the tab.

It would probably be easiest if you picked the customer on the main form,
and then had the subforms linked to the main form so that they picked up the
Customer Id that way.
 
R

Rick Brandt

Prince said:
If I have 2 tabs on a form, how do I get each tab to have different
information from different tables. Example: I'm creating a databade where the
first tab is general client information and the second tab is important dates
to remember for each client. How would you go about designing it or
programming it so I can haver the form open and view 1 clients general
information and click on their important dates and then switch clients and
view their general information and important dates?

Place subforms on all tabs but one. The parent form can host one of the tabs.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top