MULTI-TAB PAGES WITHIN A FORM

I’ve created a form with multiple sub-forms. To appease other users and make
this form as user friendly as possible - I would like to create multi-tab
pages and have each page contain data about a singular study, where each tab
would show a specific study title or studyID relating to the researcher on
the main form. The number of tabs would be contingent upon the number of
studies by a researcher.

Any suggestions?

Thank you in advance.

Bill:

At first glance I would say you may be looking at a normalization issue with
the design of your database.

From what is sounds like . . . each of your tabs should represent a separate
table of data, but it sounds like you are attempting to display specific
records from a table on different tabs according to some criteria you have
come up with.

If this makes sense or seem like the direction you are heading please
confirm. I will be happy to share some direction.

Seth


"BillA" wrote:

I’ve created a form with multiple sub-forms. To appease other users and make
this form as user friendly as possible - I would like to create multi-tab
pages and have each page contain data about a singular study, where each tab
would show a specific study title or studyID relating to the researcher on
the main form. The number of tabs would be contingent upon the number of
studies by a researcher.

Any suggestions?

Thank you in advance.

Hello Seth:

You are correct I would like "to display specific records from a table on
different tabs." Is this possible?

Thank you for your time.
Bill

"Seth Schwarm" wrote:

Bill:

At first glance I would say you may be looking at a normalization issue with
the design of your database.

From what is sounds like . . . each of your tabs should represent a separate
table of data, but it sounds like you are attempting to display specific
records from a table on different tabs according to some criteria you have
come up with.

If this makes sense or seem like the direction you are heading please
confirm. I will be happy to share some direction.

Seth


"BillA" wrote:

I’ve created a form with multiple sub-forms. To appease other users and make
this form as user friendly as possible - I would like to create multi-tab
pages and have each page contain data about a singular study, where each tab
would show a specific study title or studyID relating to the researcher on
the main form. The number of tabs would be contingent upon the number of
studies by a researcher.

Any suggestions?

Thank you in advance.

On Sat, 2 Dec 2006 09:19:00 -0800, BillA
wrote:

Hello Seth:

You are correct I would like "to display specific records from a table on
different tabs." Is this possible?

Only by having a Subform on each tab page, each subform being based on
a query selecting a different set of records.

Why? What distinguishes the desired records?

John W. Vinson[MVP]

I guess what I am trying to do is see how far you can take tabs. What I
would like to know is; can each tab contain different records. The records
would be retrieved from a query and would be related to the researcher in the
main form.

Thank you for your time.

"John Vinson" wrote:

On Sat, 2 Dec 2006 09:19:00 -0800, BillA
wrote:

Hello Seth:

You are correct I would like "to display specific records from a table on
different tabs." Is this possible?

Only by having a Subform on each tab page, each subform being based on
a query selecting a different set of records.

Why? What distinguishes the desired records?

John W. Vinson[MVP]

On Mon, 4 Dec 2006 11:19:00 -0800, BillA
wrote:

I guess what I am trying to do is see how far you can take tabs. What I
would like to know is; can each tab contain different records. The records
would be retrieved from a query and would be related to the researcher in the
main form.

If you have a question, please ask it. Remember, we cannot see your
application, do not know your data structure, and cannot read your
mind.

John W. Vinson[MVP]

Bill:

Sorry I couldn't respond sooner. MS site kept having an error and would not
allow me to reply.

You can certainly use tabs to accomplish your goal. However, you might find
it more effective to place a combo box on your main form and your subform on
the main form (scrap a tab control for this purpose).

You would use the combo box as a filtering mechanism for the displayed
subform. Let's say you have a field that would represent a category stored
with each record in your subform. You could make the unique contents of that
field be the row source for your combo box. You would then add a snippet of
code to the AfterUpdate event of your combo box which would requery your
subform and thus filter it. You would enter criteria in the query your
subform is based on - Ex. Forms!YourFormNameHere!ComboBoxNameHere

The code would be similar to this -

Me!SubformNameHere.Requery

By using the solution I am proposing, you avoid a burdensome and unnecessary
maintenance issue. If you manually create tabs and accompanying queries and
subforms, you must alter your form every time a new 'category' of an entry is
created (within the records of the subform). With the method I am
proposing, your combo box will actively read the data stored in the table the
subform is based on and the snippet of code will 'filter' the contents of the
subform to match the criteria chosen in the combo box.


Happy building.

Seth


"BillA" wrote:

I guess what I am trying to do is see how far you can take tabs. What I
would like to know is; can each tab contain different records. The records
would be retrieved from a query and would be related to the researcher in the
main form.

Thank you for your time.

"John Vinson" wrote:

On Sat, 2 Dec 2006 09:19:00 -0800, BillA
wrote:

Hello Seth:

You are correct I would like "to display specific records from a table on
different tabs." Is this possible?

Only by having a Subform on each tab page, each subform being based on
a query selecting a different set of records.

Why? What distinguishes the desired records?

John W. Vinson[MVP]