March 4th, 2010, 06:15 AM
posted to microsoft.public.access.gettingstarted
|
|
Subform help for a case management database
Hello Gina
I will repost this question with more details.
Thank you.
"Gina Whipp" wrote:
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.
.
|