>>I would like to allow my users to click on a column and the grid gets sorted by that column (this is implemented already) then if they want to add another column to the sorting, they can ctrl+click on the next column so the order will be by the first column, then the second column and so on.
>>
>>I have implemented this by using a "sort by" grid that contains user friendly names of fields in the grid's RecordSource and a column to specify "ascending or descending". It is a grid with mover bars that lets the user specify the order of the fields that are used to do the sorting. When they have the sort set up, they click a button that says "Sort Now".
>>
>>I do not have the code handy right now - at a client site, but you can find the grid with the mover bars in one of our old Kitbox Columns. I do not have the exact month right now but I can let you know later...
>
>Thanks Marcia,
>
>I'll see if I can dig it up myself too.
Hi,

Marcia's class is an easy to use and a must-have in case you can't find it and Marcia allows I could supply you the code.
Also very usefull is Graig Booyd's class this one to be found at: http://www.sweetpotatosoftware.com/spsblog/CommentView,guid,d6d71562-1655-4518-9341-527932970583.aspx,

Regards,

Koen