forest8,

After reading and REreading your post I am not sure what the real
question(s) is(are). However, from what I can tell we're going to need some
table information and relationship information.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"forest8" wrote in message
...
Hi

I have a case management database where there is one main form and a
subform.

The subform is a tab control (with 5 tabs).

Within each tab control is a subform which also consists of a tab control.

The key for the database is the StudentID.

What I want to do is to be able to see all the subforms for a particular
student. So if I choose to see all the pertinent information collected for
Student01 (aka John Smith), when I navigate through the subform, only John's
information will appear.

The Subform has a tabcontrol based on themes. For each theme, the tabcontrol
are based on subthemes. I was able to create a one-to-many relationships
between my main table (Table/Query) and all the sub tables (Related
Table/Query).

First of all, I can't seem to link the MasterID with the ChildID in the
subforms of the subforms. If I didn't use a contained tabcontrol within the
subform, I have to cycle through all the records.

If I try to use a query, each time I open my database, I need to select my
parameter value (I want it to be seanless).

If I put each form within a single tab control, I have over 40 tabs. This is
the reason for the form with the initial subcontrol since it's based on
themes.

Any help is greatly appreciated.

Thank you in advance.