Determining whther the user is setting or removing the filter...

I have a form where I allow the use of "filter by form". I want to run some
code when the user removes the filter - but I have no way of knowing if they
are removing or setting the filter in the "apply filter" event. Is there an
easy way to tell whether the user just applied the filter (pushed the filter
button in) or has removed the filter (pushed the filter button the second
time) without having to keep track of a variable each time the user clicks
the filter button?

Thanks,

Brad

I've found that you can check the ApplyType variable of
the ApplyFilter event. If the ApplyType =1 then the user
has just set a filter. Likewise, ApplyType will be 0
when the user removes the filter.

Hope this helps to solve your problem,
John Whitney

-----Original Message-----
I have a form where I allow the use of "filter by form".
I want to run some
code when the user removes the filter - but I have no
way of knowing if they
are removing or setting the filter in the "apply filter"
event. Is there an
easy way to tell whether the user just applied the
filter (pushed the filter
button in) or has removed the filter (pushed the filter
button the second
time) without having to keep track of a variable each
time the user clicks
the filter button?

Thanks,

Brad


.