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.