I am trying to setup a grid to display the results of a SQL using RecordSourceType=1. I also want the click of the headers to set the order of the SQL to that column. Unfortunatly, when I run the query, the grid loses sope of the cursor and the code in the headers (Click) is lost. I see that there is a RecordSourceType=4 (SQL) but there is NO documentation on it. It seems to me that using RecordSourceType=4 would allow me to change the Group By in the SQL without losing the cursor.

Any Ideas?

Thank you.

Todd Cottengim