I have a text box and a combo box that are used to input criteria for a query. The text box is used to inut a value so that the query returns the top "N" records, the combo box further narrows the data. Those two controls are on a main form. On this main form, I also have a sub form whose source object is the query previously mentioned. Ultimately I'm trying trying to create a form where you input specific values into the main form controls, and the sub form populates with the data.
I have cmd button that runs the query great, however, I would like the sub form to update as well.
Thanks!