>Now, I see some more details. In this particular situation you should reset Grid.ColumnCount property, and all Column.ControlSources. This is the price for overriding Grid.Recordsource. If your recordset is not really big, you may change your design, and just repopulate Recordsource. What's actually Recordsource now?

ed,
recordsourcetype is set to alias, recordsource is 'assignments'. a small table.