Query tied to form to open records but subforms not updating

[pbDudley]

Hello


I have a few append queries to add data to tables
Then I created a form so users can add data to the tables that I couldnt get with the append queries
To do this I create a query and use the criteria: [ENTER PLAN], the user enters the plan and the form opens with the table data
Now I dragged a couple other tables onto this form and went through the wizard to add a table subform

How would I get the subforms to update with the PLAN number as well? Its only updating the query that the form was created from but not the subform.

I created all of my relationships, the sub form wizard is showing which field to join to, the PLAN number


Thanks

[June7]

Are subform container control Master/Child Link properties set?

If you want to provide db for analysis, follow instructions at bottom of my post.

[pbDudley]

No they weren't but you just gave me enough information to do it. I went into the subform form properties and set the master/child fields to the PLAN field and now they are joined. I didn't know that, thank you.