chrisjames25
Registered User.
- Local time
- Today, 16:23
- Joined
- Dec 1, 2014
- Messages
- 401
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.
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.