I still can't seem to clear the contents of the filter by form criteria - it clears the filter by form from the screen but when I re-click on the filter by form the criteria is still there.
Totally frustrated.
Thanks for your help but I think I miss-represented my question - I don't need a button to close the filter by form - rather I would like a button that clears the contents of filter by form with the click of a button. When I just close it, the previous filter is always still there. Is there...
I have created quite a large database and have popped it out for general usage - the problem is everytime someone filters by form to bring up info they forget to clear it for the next time. Is there a button I can program with this command - clear filter - and what command would I use.
Thanks...
Sorry me again, I apologise for my lack of ability, I am genuinely stuck with this. On reflection it made sense to use VBA - I created the following as mentioned. My form name is info - when I open the report now I get the message - unable to find form name info - I am totally confused. Could...
I have tried what you have suggested which made perfect sense - but I keep getting the error message - Me. macro not found?
What am I doing wrong.
Thanks
Tina
Is it possible to create reports from Filter by form - I have a large database with multi office choices - I might need to select a haulier which covers three different areas and would like to be able to filter by form and then run a report from it. Does this sound possible. Please excuse my...
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.