By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Filter by form - clear grid when form opens

P: n/a
When a form opens, the most recently used filter is retained. How do I set
it to clear the grid when it opens (or when it closes for that matter)?
I'm using docmd.openform to open it.
Nov 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sun, 19 Nov 2006 04:36:49 -0000, "JohnM" <jo**@jmawer.demon.co.uk>
wrote:

In the Form_Open event write:
Me.Filter = ""

-Tom.

>When a form opens, the most recently used filter is retained. How do I set
it to clear the grid when it opens (or when it closes for that matter)?
I'm using docmd.openform to open it.
Nov 19 '06 #2

P: n/a
JohnM wrote:
When a form opens, the most recently used filter is retained. How do I set
it to clear the grid when it opens (or when it closes for that matter)?
In the form's open event:

Me.FilterOn = False
RunCommand acCmdClearGrid

In the form's unload event:

Me.Filter = ""

--
Message posted via http://www.accessmonster.com

Nov 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.