>
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.