Show All Records button??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a button that sets a filter via a custom query. This will show the
records the user searched for via a Table on a form. My question is: How do
I remove this filter or "Show-All" records again, using another button for
the user?
 
I have a button that sets a filter via a custom query. This will show the
records the user searched for via a Table on a form. My question is: How do
I remove this filter or "Show-All" records again, using another button for
the user?

The button's Click event should contain a pair of lines

Me.Filter = ""
Me.FilterOn = False


John W. Vinson[MVP]
 
Back
Top