>>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
>
>Nothing, This is default behavior of the Grid. If you close the Table/Cursor which is RecordSource of the Grid the Grid becomes unusable. The better way is to use so called Save Select. I think Andy and Marcia have an article how to do this.
>(I see Tore already show you how to do this)
>Other way it to reset the recordsource before you refresh the select and set it back after that:
>
>thisform.Grid1.RecordSource = []
>SELECT ..... INTO CURSOR SomeName;
>thisform.Grid1.RecordSource = [SomeName]
>
I think also that a CA handles all this internally - the "Safe Select" part I mean.