I assume you want to remove the filter that access places in the forms property window because it continues to apply the filter the next time you open the form. If that's the case, you can turn the filter off when you close the form.
Me.FilterOn = False
Thanks for the response but I've tried that it works but it's not what I wanted although the filter is removed the last filter that was run is automatically saved in design changes.
Becaus it see's the changes as minor it saves the filter within design changes when closing the form this causes the form to take ages to close.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.