>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