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.