>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.
Edward Pikman
Independent Consultant