How to completely clear a filter when in form view | Access forum

Hi,

I have a form which brings up a long list of company names - users need to be able to quickly find the company that they are looking for, however the exact name is rarely known. What I have done is to place buttons on this form with the aim to run filters as per the users request.

e.g.
Button "Find company name that starts with [letters]"
I have set this to run a macro which applies a filter such that it will ask you to: Enter first few letters

This is great and brings up exactly what we asked for - I have also placed a button with the action to "Remove all filters".

However, even having removed this filter so that all companies are once again visible, if the user then wants to look for another company with DIFFERENT starting letters, the Button no longer asks: "Enter first few letters" and automatically filters the form again to their previous input.

How can I resolve this?! at the moment I have taken the long way round and I have each button opening a new (almost identical) form which is based on that particular query. I really do not think that this is the best way and I would love for users to only have one Company Names form open which tends to all their search needs.

Thank you for your help!