>Folks-
>I am trying to set up a grid which lists names, addresses, etc. of employees. I would like the user to be able to double click on the line of choice and be taken to another screen with that employee's information. The problem is that the double click event (DblClick) of the Text object works the first time, but when the grid is refreshed with another data set (After a select statement and setting recordsource to the new cursor), the double click event is lost (However, the double click event of the Grid is not lost). How can I make it such that the double click event of the text is not lost (Or how can I restore it?).
>
>Any help will be greatly appreciated.
>
>Thanks,
>Binoy W.
As you said, you may either restore it or preserve it. If you want to restore, you may subclass textbox and readd it to column (addobject) after each rebuilding of grid recordsource. If you want to preserve it, then you should avoiding this recordsource rebuilding itself.
Edward Pikman
Independent Consultant