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.