A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help with data source for tab control



 
 
Thread Tools Display Modes
  #1  
Old August 4th, 2006, 01:32 AM posted to microsoft.public.access.forms
4saken
external usenet poster
 
Posts: 9
Default 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  
Old August 4th, 2006, 01:43 AM posted to microsoft.public.access.forms
strive4peace
external usenet poster
 
Posts: 1,670
Default 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  
Old August 4th, 2006, 02:10 AM posted to microsoft.public.access.forms
John Vinson
external usenet poster
 
Posts: 4,033
Default 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  
Old August 6th, 2006, 02:13 PM posted to microsoft.public.access.forms
4saken
external usenet poster
 
Posts: 9
Default 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  
Old August 7th, 2006, 05:09 AM posted to microsoft.public.access.forms
strive4peace
external usenet poster
 
Posts: 1,670
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.