Different tabs/different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 
Back
Top