Multiple tables with (1) tabbed form

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

Guest

Can you use multiple record sources (tables) with (1) tabbed form? For
example, if I have (3) tables and I have (1) tabbed form with (3) tabs and I
want tab 1 to use table 1, tab 2 to use table 2 and tab 3 to use table 3. I
can only point to (1) record source (table) for the entire tabbed control,
thus it appears that all (3) tabs have to share the same record source or
table. I must be missing something, that doesnt seem useful to have a
multi-tab form limited to (1) record source (table).

Any assistance would be greatly appreciated! Thanks everyone, -Rob
 
Yes

Just create a sub-form for each table required, link the tables to each
sub-form and then place the three sub-forms on each tab on your main form.
 
You can place 3 Subforms on 3 different Tabs and each Subform can have a
different RecordSource.

Another alternative is to place only 1 SubformControl on top of the
TabControl and use code to swap SourceObjects (the Forms being used as
"Subform").
 
Back
Top