Multiple tables with (1) tabbed form

[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

 

[Guest]

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.

 

[Van T. Dinh]

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").

 

[Guest]

To add to the answers that you have already received from Van and Peter, you
may want to consider implementing the Tab-On-Demand technique. See the
section titled "Speed up Tab controls" here for instructions on how to do
this:

http://www.access.qbuilt.com/html/multiuser_applications.html


Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________