Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Subform linked to Subform not updating 2nd Subform

Subform linked to Subform not updating 2nd Subform

Subform linked to Subform not updating 2nd Subform

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

 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.

RE: Subform linked to Subform not updating 2nd Subform

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.

John A. Gilman

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close