>How can I change the recordsource of a grid to another table with a the same structure.
>Assume tableA is the current recordsource
>If I go...

>grid.recordsource= tableB
>grid.refresh
>

>Some of the columns show data from the new table and most contain current record data from tableA for every record of tableB.
>This is despite the fact that the controlsource for each column does not contain the table alias.

David, when you change Grid.RecordSource all Column.ControlSourse are gone. You are supposed to reset them in your code.

Nick