Subforms not auto-linking to

CrystalSurfer

Matrix activist
Local time
Yesterday, 18:37
Joined
Jan 11, 2006
Messages
75
I have a main form with Client details on.
There is a subform that lists 'Categories' that a client belongs to. (This is a continuous form listing records in a ClientCat table)
Beneath that, is a tab control with other subforms on. 2 of which are linked (via Link Child/Master properties) to the Categories form above, so that when a Category is selected the 2 subforms then display the relevant data.

My problem is that when I display the main form for the first time the 2 subforms on the tab control are not displaying the related data for the first Category listed (which Access does by default), they are just blank.
It works fine when I click on a Category record, just not when it initially displays.

I've tried various methods in various events but to no avail.
Any ideas please?
Thanks.
 
I have something similar. StudentData Main form, Tab Control linked to the Main form with Master/Child Properties, THEN the next two forms are inside the tab control Subform A and Sub-subform B(inside Subform A). This works. They all share a common ID number with the Main Form. Sub-Subform B shares an additional ID with Subform A.

Main -> Tab Control
------------> Subform A =>> Sub-Subform B

Is that oversimplified?

Goh
 
Goh,
I guess you mean your subform A has the Link to the main form and not the tab control? As I dont think you can link a tab control to anything.
But I see what you mean.
I have a slight difference in that I have a separate subform on the main form that controls which 'Client's Category' to display on the 2 other subforms.
It works fine when selecting a different Category but does not display any of the detail when first displaying.
:confused:
 
Can you offer a copy of the structure with a generic sample set of data?
 
GohDiamond said:
Can you offer a copy of the structure with a generic sample set of data?

Thanks for that.
Work is extremely hectic at the mo with a website going live so I'll post it up when Ive got a spare min.

Surfer
 

Users who are viewing this thread

Back
Top Bottom