Macro to Run RemoveFilter/Sort

[Ryan]

I have a Query that works fine, and displays on the sub form.



If I click the ((LEFT CLICK)) command button though, it displays the query in a box and on the form.

If I ((RIGHT CLICK)) click the command button, then a options comes up. One which is RemoveFilter /Sort.

By using that, I dont get the query result in a extra datasheet, I get it just in the subform. Which is perfect and exactly what I want.

I want a Macro so I dont have to right click, then click the Removefilter/Sort button.

Unless there is another way??

Thanks Ryan.
*********************************************
I discovered the answer with a few hours of luck!

Make a Macro with the ShowAllRecord Command and save it
On the Main form, made a new command button, attached the macro to it.

While on click, it displayed the query info in the SubForm.

(The query had the filter built in, by using data from the MainForm."Two drop down boxes") Also that extra query box doesnt display, it now works perfect! Thank everyone for the great help!