The recordsource must be a separate cursor, and not the result of the query.

Select ** into cursor curDummy
Select CursorGrid && this is the recordsource for teh grid
zap
append from dbf('curDummy')
yourgrid.refresh()

>I have a grid that has an sql statement as a recordsource as an sql statement, and recordsourcetype as sql. when the grid gets focus, I requery the sql.I lose all of my settings for the grid and any code that I placed in the text box.
>
>What did I forget to do?
>
>TIA,
>Mike