>Hi Washington,
>
>>My grid is loosing its properties when I recreate it recordsource property. Also, its loosing the code that I have assigned to some of the events in some of the columns. How do I reassign them programmatically??
>
>There is a trick to this, before changing your RecordSource, set it "" then you can set it to the new source and all will not be lost.

Hi Mike,

Thanks for the tip, But it still not what I want. I have code in the dblclick method of a textbox in a grid. I the code in the dblclick event does not fire after I reset the recordsource.

Any ideas? Thanks in advance