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

  • Thread starter Thread starter Brad Pears
  • Start date Start date
B

Brad Pears

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
 
Back
Top