Tabbed Pages

[David Tro]

Hello,
Can anyone help a novice here.
In designing a form with tabbed pages on it is it possible to have a tabbed page no 1 taking info from table no 1 then having tabbed page no 2 taking info from table no 2 and so on?
How would I go about this? any help gratefully needed
Thanks

 

[Rob.Mills]

Well you can only have one recordsource for the form but you can combine table in that recordsource that have some kind of relationship. And then you can put whatever fields you want on each tab.

 

[wizcow]

David

You could also combine tableA and tableB into a query.
Use the query as your forms record source and
put only tableA fields on TabA and only tableB fields on TabB.

Tom

 

[Oldsoftboss]

Or perhaps put a subform on each page with the border style set to transperant to give the impression of the data being on the actual page, then base each subform on individual tables.
Just a thoughtHTH
Dave

 

[David Tro]

Tabbed pages

Thanks for all the tips.
I don't know if I will manage to get what I am after as I am very new to Access to will try everything you all suggested.
Thanks
David

 

[aussie_user]

tabbed pages various record sources

How did you make out David? I've been trying to figure out how to do the exact same thing. My problem is the amount of data from the various tables is so big that I don't want to put it all in one query so think I'll have a try with the subform approach.

 

[aussie_user]

tabbed form

Just saw something interesting while looking through the Contacts database that comes with Access. The contacts form is a tabbed form and on the record source for the form it has

SELECT [Contacts].[ContactID], [Contacts].[FirstName], [Contacts].[LastName], [Contacts].[Dear], [Contacts].[CompanyID], [Contacts].[Title], [Contacts].[WorkPhone], [Contacts].[WorkExtension], [Contacts].[HomePhone], [Contacts].[MobilePhone], [Contacts].[FaxNumber], [Contacts].[PagerNumber], [Contacts].[EmailName], [Contacts].[Birthdate], [Contacts].[LastMeetingDate], [Contacts].[ContactTypeID], [Contacts].[ReferredBy], [Contacts].[Notes], [Contacts].[MaritalStatus], [Contacts].[SpouseName], [Contacts].[SpousesInterests], [Contacts].[ChildrenNames], [Contacts].[Hometown], [Contacts].[ContactsInterests], [Company].[CompanyName], [Company].[Address], [Company].[City], [Company].[StateOrProvince], [Company].[PostalCode], [Company].[Region], [Company].[Country], [Company].[WebSite] FROM Company RIGHT JOIN Contacts ON [Company].[CompanyID]=[Contacts].[CompanyID] ORDER BY [Contacts].[LastName];

which appears to pull data from 2 different tables. This might be a way to get around using subforms. I've been trying to use subforms on a tabbed form but the records have to be changed manually on each tabbed page with a subform on it which seems to defeat the purpose of having a tabbed form.