Show All Records button??

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?
 
J

John Vinson

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?
Click to expand...

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

Me.Filter = ""
Me.FilterOn = False


John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

filtering a form based on a filter on an open form 2
Show all records 12
First Subform record gets modified when closing form 3
Resetting the form filter filter for a new report 4
Need form filtered based on criteria 1
Access Access 2010: Activating controls in a form after filter by form 0
FILTERED REPORT 1
show all 1

Top