>>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.
If you will use SET DELETED ON instead of PACK, then you don't need to reset Recordsource, i.e. it's enough to call Grid.Refresh to refresh grid content. If you still want to have PACK, then you better collect non-deleted records to cursor and use this read-write cursor as permanent Grid.Recordsource. It's again will allow your grid to preserve number of columns and other settings.
Edward Pikman
Independent Consultant