How do I create a clear filters button in a form?

X

Xtremist9

Just looking for a way to have a quick way to clear any filters created on a
form. If its a visual basic command please be specific on how I do it
please. :) thanks in advance for any help!

Regards,
Richard Anderson
 
M

Marshall Barton

Xtremist9 said:
Just looking for a way to have a quick way to clear any filters created on a
form. If its a visual basic command please be specific on how I do it
please.
Click to expand...


You can turn off the current filter by using:
Me.FilterOn = False

You can clear it with:
Me.Filter = ""

If that's not what you want, please explain what you want in
more detail.
 
B

BobbyBob

How are the filters applied? If they are applied by using the toolbar filter
buttons, then they can be removed using the toolbar buttons.
 

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

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Crating User Form to Add Names 1
Clearing Fields in a Word Form 5
Creating Forms 0
How do I clear a form? 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Request Form - Alert Team Member 0
Numbered list problem 6

Top