The "go top" and refresh the grid did not do it.

But I did come across this: It works, but the wrong data appears in the grid.


PRB: Cursor-Based Grid Goes Blank If SQL SELECT Resets Cursor

SYMPTOMS
If a grid's RecordSource property is set to a cursor, and then the SQL SELECT command resets the cursor, the grid appears blank if the RecordSource property is not set back to itself.

The following command will refresh the grid properly if a SQL SELECT is run to rebuild the cursor, but if the grid's column or header properties have been customized, these customized changes will be lost and the grid's column and header properties will change back to their default settings:

THISFORM.GRID1.RECORDSOURCE=THISFORM.GRID1.RECORDSOURCE