I have an Access Project connected to a SQL Server backend. There are a number of forms which are used to view the data and the "Filter by Form" button is used often to restrict the records displayed.
Whenever the users apply a filter and then close the form, they are asked whether they want to save their changes to the form. The only change they have made is to apply a temporary filter which they never want to save. In any case, the project is read-only so they cannot actually save the change anyway.
Is there any way to stop them being prompted if their only change is to apply a filter? I have tried intercepting the close event in order to undo the filter, but the prompt seems to come up before any of the events fire.