We have a database which uses the navigation subform tabs in MS Access 2010. The front screen is a search facility where the user can search for an employee name and it will filter out the correct person.
However, when they click on another tab to open a different navigation subform this filtered form prompts to save the changes. I have searched for ways to prevent this and tried removing the filter on unload, lost focus and close but those actions take place before the filter removes so it isn't doing the job.
The only solutions I have found require a close button which isn't appropriate where the user is in the Navigation Subforms as they just click from tab to tab.
Does anyone have any idea how I can prevent the save prompt. I'd be most grateful!
Thank you in advance