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

Filtered view of Visio Chart 0
Sorting and filtering text 0
WORD VBA Search and switch to advanced ... 1
Request Form - Alert Team Member 0
Command Button to Sort and Filter by Selection 3
How to eliminate the sorting and filtering buttons from ACC2007 forms 1
Run in to a Problem Creating Button 0
Filtering changes the subform sort order permanently? 0

Top