>
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...
Hi Marcia,
I've scanned through my old copies of FoxTalk but didn't see anything like what you mentioned. If you could let me know what month it was in that would be great.