How to run "advanced filter/sort" from a button?

J

Jimbo213

SOLVED this myself.

1) created/saved qryFIND with Name criteria "*" & [enter partial name] & "*"
2) added button to form
3) went to button > OnClick > macro property
4) macro has Action=ApplyFilter with FilterName = qryFIND

works real slick.

Posting here to benefit others who search.
 

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

How to eliminate the sorting and filtering buttons from ACC2007 forms 1
Command Button to Sort and Filter by Selection 3
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Form Filter will not delete 2
Need Help to Create 1 A to Z Command Button (to sort - not filter) 2
ADVANCE FILTER SORT WINDOW 1
multiple filters 4
Filter Form doesn't close 2

Top