remove filter

D

Dan

I have a form that is filtered on several different values and i was
wondering if there is an easy way to make a button that removes the filter
from just one of the fields with out reapplying the filter.
 
J

John Vinson

I have a form that is filtered on several different values and i was
wondering if there is an easy way to make a button that removes the filter
from just one of the fields with out reapplying the filter.
Click to expand...

There's only *one* filter for a Form - which may reference multiple
fields. The Filter string is essentially a SQL WHERE clause as in a
query; so it may contain several criteria with AND, OR, or
parenthesized logic.

Therefore no - you can't "remove the filter from just one of the
fields"; you need to reconstruct and reapply the filter.

John W. Vinson[MVP]
 
Top