how to detect if a sort has been applied using ac cmdfiltermenu (1 Viewer)

chrisjames25

Registered User.
Local time
Today, 23:30
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.
 

Ranman256

Well-known member
Local time
Today, 19:30
Joined
Apr 9, 2015
Messages
4,339
you don't need to detect a sort, just resort the way you want.
or apply another filter.
 

isladogs

MVP / VIP
Local time
Today, 23:30
Joined
Jan 14, 2017
Messages
18,186
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!
 

Attachments

  • StudentExplorer1.jpg
    StudentExplorer1.jpg
    106.8 KB · Views: 26
  • StudentExplorer2.PNG
    StudentExplorer2.PNG
    59.3 KB · Views: 20

Users who are viewing this thread

Top Bottom