Hi Gang!
I have an Access 2010 database with only one table at the moment. I created a main form with some basic controls for users to view and make changes to the table through the interface rather than the tables themselves. I inserted a subform into this form (called Table1 Subform) that shows the table itself with no filters. What I am trying to do is create a button that takes a client name that the user enters and when the button is clicked the subform applies that filter and returns matching client names. Here is the problem I run into. The table1 subform does take the entered client name and filters the data...but ONLY if I have the table1 subform open in another panel and it only updates that panel. The subfomr on the main page continues to show the entire table. How can I get this subform to update on my main form and not have to open the subform in a different pane?
THanks
Bremen
I have an Access 2010 database with only one table at the moment. I created a main form with some basic controls for users to view and make changes to the table through the interface rather than the tables themselves. I inserted a subform into this form (called Table1 Subform) that shows the table itself with no filters. What I am trying to do is create a button that takes a client name that the user enters and when the button is clicked the subform applies that filter and returns matching client names. Here is the problem I run into. The table1 subform does take the entered client name and filters the data...but ONLY if I have the table1 subform open in another panel and it only updates that panel. The subfomr on the main page continues to show the entire table. How can I get this subform to update on my main form and not have to open the subform in a different pane?
THanks
Bremen
