Need help with data source for tab control

4

4saken

I have a form that will display GENERAL info of an individual, and two
additional tabs (LEGAL & HISTORY). In design view, I view the properties for
each tab, but they all inherit the same data source as the previos tab. How
can I force each tab to have it's own data source (coming from 3 different
tables for each tab)?

Thanks.
 
S

strive4peace

Tabs do not have data sources -- you will need a subform on the tabs
whose datasource is not the data source for the main form


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
J

John Vinson

I have a form that will display GENERAL info of an individual, and two
additional tabs (LEGAL & HISTORY). In design view, I view the properties for
each tab, but they all inherit the same data source as the previos tab. How
can I force each tab to have it's own data source (coming from 3 different
tables for each tab)?

Thanks.
Click to expand...

Tab controls don't have data sources. They're just tools for managing
screen real estate; they don't have Recordsources or Control Sources!

If you need three tables, you'll need to use Subforms. You can perhaps
put the controls from the GENERAL table on one tab, and put a Subform
Control on each of two other tabs, using the LEGAL and HISTORY tables
as their Recordsources.

John W. Vinson[MVP]
 
4

4saken

This helped me out. Thanks!

strive4peace said:
Tabs do not have data sources -- you will need a subform on the tabs
whose datasource is not the data source for the main form


Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
Click to expand...
 
S

strive4peace

you're welcome ;) happy to help

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote programming and Training
strive4peace2006 at yahoo.com
*
 
Top