Subform help for a case management database

  • Thread starter Thread starter forest8
  • Start date Start date
F

forest8

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.
 
Hello,

It sounds like your underlying problem is tables that are not correctly
designed. At least you should have the design reviewed. You can post your
tables here or if you would rather work with someone off-line, I can help
you. I provide help with Access, Excel and Word applications for a small
fee. My fee to look at the design of your tables would be very modest. Let
me look at your tables and then we can go from there.

Steve
(e-mail address removed)
 
Steve said:
You can post your tables here or if you would rather work with some loser
off-line, I can help you. I provide help with Access, Excel and Word
applications for a small fee. My fee to look at the design of your tables
would be very modest. Let me look at your tables and then we can go from
there.

Steve
Click to expand...


Stevie, you are such a loser. You have no idea about ethics or software
design.



Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP
 
Hi.

So is there an answer for me?

Thanks

Stop$teve said:
--
Get lost $teve. Go away... far away....

Again... Get lost $teve. Go away... far away....
No-one wants you here... no-one needs you here...

This newsgroup is meant for FREE help..
No-one wants you here... no-one needs you here...
OP look at http://home.tiscali.nl/arracom/whoissteve.html
(Website has been updated and has a new 'look'... we have passed 11.500 pageloads... it's a shame !!)

Arno R


.
Click to expand...
 
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

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.
 
I can think of several things to try. Some of these are speculation on my part.

You can try manually setting the values for Link Child Fields and Link Master
Fields. The values don't have to be a field.

Assumptions:
== each of the sub-subforms has a StudentID field
== there is a control on the Master form that contains the current StudentID
field

Link Child Fields: [StudentID]
Master Link Fields: [Forms]![Name of Master Form]![Name of StudentID CONTROL]

Next thing to try. Make sure each subform has a record source that has the
studentid and the Master form and subform are linked on the StudentID fields.

Now try setting up the links between the subform and the sub-subform based on
the studentID fields in the subform and sub-subform. Again you can refer to
a control on the subform in the Master Link Fields property. I have done this
and I only had to use [Name of StudentID Control] as the reference.

IF neither of these work, I would try setting up the underlying queries of the
sub-subforms to reference a control on the Master form as criteria. And then
use REQUERY of each of the subforms whenever the master form selection changed.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top