>>Well, I got the grid attached to a cursor, but it is completely blank. At least there are no errors when the form runs! This is my first time using a grid, btw. I know there is an issue with the grid loosing its recordsource when refreshed, but am at a loss as to where to put the code to get anything to display. Any suggestions would be appreciated.
>
>Make sure the cursor exists before the grid is initialized. Also make sure the cursor doesn't stop existing any time while the grid exists.
>
>-Michelle
Good point. This also goes for reexecuting the SQL that creates the cursor, because SQL first deletes the existing and then creates the new one. IF you must do this, then do it like this:
MyGrid.RecordSource = ""
SELECT * FROM MyTable INTO CURSOR MyCursor
Mygrid.RecordSource = "MyCursor"
Erik Moore
Clientelligence