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