>Currently I have a grid on a form with several columns. Currently I had placed a check box on the form to sort the grid. In the click event of the check box I trigger a listbox which displays the fields to sort. Everything works fine.
>
>I want to move the code to each column header, but when I run the code, it works the first time but won't after that unless I close the form down. I would like to be able to use the grid headers like the headers in Windows Explorer(sorting of files by date, name etc..) so I can sort on the field just by clicking the grid header of the desired column.
>
>Thanks in Advance.
>
>Scott

It should work as long as you use SET ORDER TO ... in header.click event. If you use SORT and override grid.recordsource then you may get in some troubles.