Jim,

I just finished an app that did a lot of this, Now that I have less hair, I can tell you what I found.

I did have a select statement in the recordsource of the grid. But in order to make it work I had to include the INTO Cursor Mycursor at the end.

Then, in order to disassociate the recordsource when re-doing the select, I re-do the select in the program using a different cursor. ibid.

thisform.grid1.recordsource = "SELECT arno, asmt, artype, asubj, astat, adue, name ;
FROM artemp INTO CURSOR Phantom"

Note the space right before the ; it is necessary if you break the line.

Play with this and it should work for you.

LOL