Display Advanced Filter
Hello,
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?
Thanks,
M. Wilson
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?
Thanks,
M. Wilson
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Database189.mdb