TAB CONTROL to load FORM

[ApexData]

I'm starting a new project. A Personnel System. I have considered
opening a single bound form to the main employee table. The user can
scroll the records to any individual. I would like to have a tab
control at the top of the form which would allow the user to select
(PERSONAL), (TRAINING),(DISIPLINARY),and (SICKLEAVE) Tabs. Each Tab
should open a FORM and display the relavant TABLE of records tied to
the Employee being viewed in the MainForm.

How do I get the Tab selected to load a (Form or SubForm Control) and
it's Table?
Can I, or should I close the Form/Table when leaving the selected Tab?

OR ... Should I just open multiple tables at startup, and make the
relevant fields available
in each Tab Page ?

ThankYou
Greg

 

[missinglinq via AccessMonster.com]

Assuming that all the tables are related in some way, why not simply use a
query that incorporates all the tables as the Record Source for the form.
Then simply place the controls for the various types of data (PERSONAL,
TRAINING, DISIPLINARYand SICKLEAVE) on the appropriate tabbed pages. It makes
it much easier all around than using subforms. Despite the many "pages" it's
really just one form, and references to controls are much easier!

 

[Rick Brandt]

Assuming that all the tables are related in some way, why not simply use a
query that incorporates all the tables as the Record Source for the form.
Then simply place the controls for the various types of data (PERSONAL,
TRAINING, DISIPLINARYand SICKLEAVE) on the appropriate tabbed pages. It makes
it much easier all around than using subforms. Despite the many "pages" it's
really just one form, and references to controls are much easier!

And if the tables have one to many relationships what will that give you? The
first record of the form will show the first record of the table on the "one
side", as will the second record, third, etc., until you finally exhaust all of
the records on the "many side". Then you will finally see the second record of
the table on the "one side". I can't imagine that being an intuitive way to
work with records. For one thing there is no immediate and obvious way to see
how many of the "many" records there are except to continue navigating until you
see those values change.