Display Advanced Filter


I have a continuous form popup form.  I want to display the advanced filter that is available in datasheet view.

Is there a way that I can create a trigger that will display the advanced filter when a user clicks on something?

M. Wilson
Who is Participating?
Jeffrey CoachmanMIS LiasonCommented:
Create an Autokeys Macro (Name="AutoKeys")
Add a submacro like this:
AutoKeys Sub Macro...meaning pressing Ctrl+Shift+F, ...will activate the code

Add a Module
Add a Public function, (called "AdvFilter") to this module like this:
Public Function AdvFilter()
    DoCmd.RunCommand acCmdAdvancedFilterSort
End Function

Open in new window

Sample db attached


Jeffrey CoachmanMIS LiasonCommented:
display the advanced filter when a user clicks on something?
...In datasheet view there is really nothing "Generic" to click on.
All you really have to click on is the textboxes.

But this would cause confusion because every time you clicked any textbox (in any record) the code would run and display the AdvFilter

You could, however, make a "Continuous Form" and then you could but a button in the form header, ...and run the code on the click event of the button, ...come to think of it, ..,this approach seems better, ...as a continuous form give you essentially the same "Multiple Records View" as a Datasheet, ...only now you have more control over object events.

Modified sample attached as well

    DoCmd.RunCommand acCmdAdvancedFilterSort
...on the
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.