I have a subform whose record source is a query. It's main form has a command button and a combo box. The value selected in the combo box on the main form dictates a piece of the criteria in the query that the subform is pulling from. The command button writes the SQL statement according to what is selected in the combo box. Here's my problem: How do I get the subform to refresh and show the new results of the query after executing the command button? Everything is working correctly, in that when I press the button on the main form the query is re-written with the value in the combo box. It's just not refreshing in the subform. It only refreshes when I close the main form and then reopen it. Is there any way to get the query to run AND refresh in a subform without having to close and reopen its parent form?? Thanks in advance for any help!!
I had the same troubles in the past with a form I was working on. My way around it was kinda tricky/stupid... I used a macro or code that went to the previous record then right back to the next record. It works fine now.