>>I'm not sure I understand what's happening to your grid after refresh (showing all columns, you say). Did you do it like I suggested?
>
>daniel, yes i followed your instructions. the table contains 9 columns and the grid contains 7 columns. once the grid refreshes it shows all 9 columns. ed was suggesting to update columns dynamically to reset the Column.Visible property.
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?
Edward Pikman
Independent Consultant