Clear Filters with code

  • Thread starter Thread starter R. Choate
  • Start date Start date
R

R. Choate

I use code to filter records when an entry is chosen from a cbobox. I need to be able to clear the filter as well. I know I can get
it to showallrecords, but if I close the form and look at its properties, I still see the filter I applied earlier. How can I clear
the filter altogether?

Thanks in advance !
 
R. Choate said:
I use code to filter records when an entry is chosen from a cbobox. I
need to be able to clear the filter as well. I know I can get it to
showallrecords, but if I close the form and look at its properties, I
still see the filter I applied earlier. How can I clear the filter
altogether?

Thanks in advance !
Click to expand...

The statement

Me.FilterOn = False

turns off the filter (same as DoCmd.ShowAllRecords), while

Me.Filter = ""

clears the Filter property.
 
Back
Top