Is it possible to activate the advanced filter/sort command from a button?

Signature
Thanks for your reply & assistance.
Jimbo213
Jimbo213 - 08 May 2008 00:03 GMT
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.