>The problem was setting nColumnCount to the grid columncount. When I re-exectuted the SQL statement, it closed the cursor and recreated it. That meant that all the grid controls were gone and had to be reset. When I reset the grid record source to the cursor, it automatically set the grid columns to the # of columns in the cursor (5). Something probably everyone else knew but that I just learned.

I see. To prevent this you can set grid recorsource to the empty string, recreate cursor and set recordsource back to the cursor.

THISFORM.grdfind.RECORDSOURCE = ""
* Recreate cursor here
THISFORM.grdfind.RECORDSOURCE = THIS.ccursorname

< snip >