Yes, each client will receive a classification only once and the subform
chosen shows specific information (really a list of questions with answers,
typed in data entry) per classification. I had the classification field from
the main table and thought once I chose the classification for the client,
then a form would popup or be populated on the main form for data entry of
answers from each client.

"kingston via AccessMonster.com" wrote:

Maybe I missed something. Does each client get only one classification value
and hence one subform? If so, I'm not sure you should use a tab control; you
can simply stack the subforms on top of each other and turn the appropriate
ones on or off.

Also, I'm not clear on how you wish to use the existing field [classification]
. Do you mean that once it is populated, the corresponding subform will
appear? You can make this happen by using the control's AfterUpdate event to
control individual subform properties such as: .Visible, .Enabled, .Locked.
For example:

Select Case Me.Classification
Case "Class1"
Me.Subform1.Visible = True
Me.Subform2.Visible = False
...
Me.Subform7.Visible = False
Case "Class2"
Me.Subform1.Visible = False
Me.Subform2.Visible = True
...
Me.Subform7.Visible = False
...
End Select


cs_vision wrote:
Great, can the existing field "classification" be used as a control for the
tab relating to the classification chosen?

Have you considered creating a tab control in your main form? It could have
7 tabs and a subform in each one corresponding to the data in the main table.
[quoted text clipped - 13 lines]
I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?

--
Message posted via http://www.accessmonster.com