Clearing a Filter by Form
Posted on 2003-03-25
Hello everyone, Heres my question!
I am using "DoCmd.RunCommand acCmdFilterByForm" to open a form in "Filter by Form" mode. This allows the user to create a custom filter to their liking. Once run, the user can then us a button I have created to push the "filtered" results to a generic report I have created. The problem I am having is more of an anoyance than anything. After filtering the records accroding to their needs. Another use may try to use this feature and find the criteria the last user entered on the "Filter by Form" screen. He/she can delete this criteria and eneter their own, but if they miss something it will fudge the reulting data.
I would like the "Filter by Form" to be cleared (no values in any field) when the user selects the button containing "DoCmd.RunCommand acCmdFilterByForm" . Can this be done and if so, anyone have any ideas?