>>Brenda,
>
>>Save the column controlsources BEFORE you blank the grids recordsource. As for copying the grids rows to an array, why would you want to do that, you already have the rows in the recordsource. Just use the recordsource.
>
>figured that one out at 3:00 am last night. thanks for you help. mostly have it working. but when recordsource = "", the grid column controlsource seems to revert to the selected table. you can see the contents of the grids columns change. any thoughts on how i can keep the original contents in the grid columns even though the recordsource = "" (i know, asking alot)
>
Brenda,
THISFORM.LockScreen = .T. before you start the process and THISFORM.LockScreen = .F. when you are finished. Just make sure there is no way for your code to miss the LockScreen = .f. line.