>>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.
Is that to understand as grid having ColumnCount = 7, as opposed to having 9 columns whereas 2 are sett Visible = .F. or something? I find that behaviour strange in that case. If you always want to show exact same columns, define that in Form Designer, that should do it.
Regards
Danijel