Remove Filter/Sort VBA

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

Guest

I would like to put a cmdbutton on my form that does exactly the same thing
as clicking on Records and then the Remove Filter/Sort combination.

I have tried me.refresh, me.repaint?, me.requery and then filter on = false
but can't seem to figure it out. I'm sure this is simple.

Proper syntax would be greatly appreciated.

Thanks in advance.
 

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

Remove sort and filters programmatically on form 2
Access03 form does not display records on open 3
filter on a form only works once 5
Reload query in form 2
Need combo box to refresh when moving to new record 2017 1
Help with comboxes filtering and sorting a query 1
VBA record filtering and filterOn property 3
remove a filter 5

Back
Top