>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]
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.