Togglebutton with the triplestate turned to True

[stakar]

I have the following problem
I want to sort a column by using the togglebutton with the triplestat
turned to True

So if i click on the togglebutton once to be sorted by A
If i click second time to be sorted by B
and at last if i click for third time to be sorted by C

Is it possible? Because i cant manage it
Thanks in advance

Stathi

 

[Tom Ogilvy]

Just use a commandbutton and use a static variable to remember what was the
last sort column. Then put in a case statement to do the new sort based on
the stored column, change the caption on the button to the next sort, record
the column used (set the variable).