grids

I have a VFP5 application that is accessing data on an MS-SQL server database.
I have a form in which I have a grid. This grid is meant to display info from a number of records from a MSSQL table.
The grid has recordsourcetype = 1 and recordsource='details'.
Each time the account changes I execute a SQL "select account,f1,f2 from details where account = m_account".
Although each time I use 'details' as the cursor name and the recordsource=details the columncount gets set to 0. Presumably because it is a diferrent physical table/cursor.
I got round this by resetting columncount,the headings and widths of each column and the datasource of each column.
This worked so far.
Now I come to my problem. The functionality required is such that the user can double click on a record in the grid and a certain piece of code is executed. This was included in the text1.dblclick for each column in the grid and is lost when a new set of records is retrieved from MSSQL. I don't see how I can recreate these methods as I have with the properties of the grid.columns.

So what I want is a grid populated from a changeable selection of records from an MSSQL table, which when the users double clicks a record a certain piece of code is executed. Any ideas on how to get what I've done so far to work or how to approach it differently from scratch?

TIA