When i define a filter for a form thru code and apply it to that form,it
will be saved in the form's property sheet in background.This causes some
troubels when i want to mix condidtions and make another filter based on
user's request.So i need to erease the filter property from the property
sheet first,before making a new filter and apply it,through code.To do this,
i use the expression: frm.filter = "" ,where frm is the target form.but
unfortunately this cant clear filter from the form's property sheet.What
expression can do this for me?(clearing filter property from the property
Any help wd be appreciated and thank you in advance.
Leave the filter property alone, it's not hurting anybody.
When you are through with the filter, you can use code to set the
FilterOn property to False:
Me.FilterOn = False
Then, whenever you want another filter, create a new Filter, either by
code and set FilterOn = True, or using Access Filter by Form (or
Selection) and hitting the Filter button. The new filter will replace