clear filter

[lynn]

I am opening a form in filter mode using the code
RunCommand acCmdFilterByForm
This works OK, but it saves the last filter criterion.
How do I tell the form to clear the grid?

thanks

 

[Bob]

Add this to your code:

DoCmd.RunCommand acCmdClearGrid