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

Automatic filter reset

P: n/a
I have a database in MS Access 2000. I have a field that needs to be
filtered repeatedly. Currently, after the field is filtered, the
filter must be manually removed prior to filtering on that field
again. Is there a way to clear a filter that is in place by simply
filtering again on the same field? I believe that newer versions of
Access may do this automatically, but I cannot find a way to
accomplish this in Access 2000. Thanks for any advice.
Feb 11 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 11 Feb 2008 13:38:33 -0800 (PST), GregC wrote:
I have a database in MS Access 2000. I have a field that needs to be
filtered repeatedly. Currently, after the field is filtered, the
filter must be manually removed prior to filtering on that field
again. Is there a way to clear a filter that is in place by simply
filtering again on the same field? I believe that newer versions of
Access may do this automatically, but I cannot find a way to
accomplish this in Access 2000. Thanks for any advice.
To remove the filter:
Right-click on the form and select Remove Filter/Sort.

You re-applying the same filter as the one you want to remove?
To re-apply the filter:
Right-click on the form again and select Apply Filter/Sort.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Feb 11 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.