If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help with data source for tab control
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. |
#2
|
|||
|
|||
Need help with data source for tab control
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 * 4saken wrote: 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. |
#3
|
|||
|
|||
Need help with data source for tab control
On Thu, 3 Aug 2006 17:32:01 -0700, 4saken
wrote: 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. 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
|
|||
|
|||
Need help with data source for tab control
This helped me out. Thanks!
"strive4peace" wrote: 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 * 4saken wrote: 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. |
#5
|
|||
|
|||
Need help with data source for tab control
you're welcome happy to help
Warm Regards, Crystal * (: have an awesome day * MVP Access Remote programming and Training strive4peace2006 at yahoo.com * 4saken wrote: This helped me out. Thanks! "strive4peace" wrote: 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 * 4saken wrote: 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. |
Thread Tools | |
Display Modes | |
|
|