>>After I viewing table in a grid, switching sourcecode from one table to an SQL result, then returning the sourcecode back to the original table I have lost the Grid.Column3.text1.dblclick code.
>>
>>How do I re-instate the dbl click for this?
>
>Before you pull the rug out from under the grid by changing the RecordSource, do this:
>
>cOldRS = thisform.oGrid.RecordSource
>thisform.oGrid.RecordSource = ""
>* get your new data here
>thisform.oGrid.RecordSource = cOldRS

Thanx,
But actually the restablished record source is not the problem.

I have code in the third column text1 double click that is cleared

It's a hefty code used to unzip and open a file for read and other stuff.

How can I provide the code back into the original location?