Removing filter

[MikeCDPQ]

When I user Filter by form, the value stay on the form's filter property until I manually go and delete it.

I have tried to Remove filter/Sort or setvalue forms!blabla.filter = ""

nothing works.

The problem is that I open other forms based on the first form's filter and I always see the same values as the filter is stuck on the 1st form.

How can I erase the filter value when I close the form ??

Thanks for any suggestion.

Mike

 

[PeasNCarrots]

Try this )

me.FilterOn = False
me.Filter =

 

[MikeCDPQ]

Hi PeasNCarrots,

Thanks for your suggestion, but it does not work. If I go to my form in design mode

The filter is still there.

Thanks