how to detect if a sort has been applied using ac cmdfiltermenu

[chrisjames25]

Hi

I have a continuous form that looks like datasheet.

I wanted to keep the finctionality of a datasheet column filter so used the ac cmdfiltermenu function in vba.

This works great and i have (with the help on here) got code that allows me to detect when a filter is applied once the drop down filter menu has appeared but what i cant figure out is how to detect if a sort has been applied using the filtermenu.

Ideally i want a way to detect that a sort has been applied and if so enable my cmd_removesort button.

Any help much appreciated.

 

[Ranman256]

you don't need to detect a sort, just resort the way you want.
or apply another filter.

 

[isladogs]

Have a look at my Student Target Grade Explorer example app
This shows which column has been sorted in 2 ways: up/down arrow on the column header and a label caption at the bottom of the form. It also shows which filter(s) have been applied visually

However I'm using a continuous form that looks like a datasheet!