I have a set of Access 2000 forms with combo boxes. Associated subforms are prefilled with data from a table. Selecting a value in the combo box (using the AfterUpdate event) should execute a macro with the RunQuery command and execute the background query which acts as a filter.
The code was working fine, but suddenly the filters stopped being applied across all 30+ forms and filters across the application. I can click filter by form and then apply filter and the records are filtered properly. Running the query which acts as the filter separately with the form open returns the proper records.