RyanPRomero
New member
- Local time
- Today, 09:50
- Joined
- Aug 30, 2009
- Messages
- 1
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.
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.