>When you assign a recordsource to a grid, and then kill that recordsource while the grid is still 'attached' to it, the grid loses its mind and forgets everyhing you told it. To preserve grid settings when changing controlsources, set the grid's Recordsource to "" and then open your table and reassign the recordsource.

Erik,
Do you know of a way to change a grid's recordsource in the form designer without it wiping out all the grid controlsources?