Automatic filter reset

[GregC]

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.

[fredg]

Re: Automatic filter reset

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