Subform linked to Subform not updating 2nd Subform

[triatron]

I have a form that has 2 subforms.. When I select an item on the main form the 2 subforms change to that item. When I change the selection Item on the 1st subform the 2nd subform does not change to the correct records.

The 3 tables are set up like this

Main
Primary key : txtReportName

1st subform table
Primary Key & linked to main table by: txtReportName
Primany Key: txtUserID

2nd subform table
Primary Key & linked to 1st subform table by: txtReportName
Primany Key & linked to 1st subform table by: txtUserID
Primary key (autonumber): numSeq

It looks like I have it all setup correctly and I can add new items to 2nd subform and table updates correctly, but when I close the main form and open it back up the 2nd subform only shows the first txtUserID from the 1st subform.

If anyone can help this problem it would help.

 

[jagilman]

I think for what you want to work, the second subform must be placed ON the first subform. If you cant do this due to design, then use the form current event of the first subform to cause the second subform to stay in sync. I use the continous form view for my subforms usually, this way the user has no control over the column width.
See if this works. [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]