Hi
In design time, the ControlSource for Columns is in {alias}.{column} form
I save the field name without alias part into .Tag property. Then the code sequence permits me to use another source for grid, even if the new source has different numbers of columns or different column order, because it reassign .ControlSource individually/columns.

You don't need to do this if the same alias is reassigned as ControlSource for grid.
.RecordSource = ''
.RecordSource = '{alias}'
will be enough.


>What does .Columns(i).Tag do? What does the .tag refer to here?
>Thanks
>Steve
>{Grid}.RecordSource = 'new_alias'
>With {Grid}
> For i = 1 To .ColumnCount
> .Columns( i ).ControlSource = .Columns(i).Tag
> Endfor
> .Refresh()
>Endwith