>>>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
>
>OK, I reset them in code, but no change in result unfortunately. Do I need to reset something else as well, such as columncount?

Basically, when all grid setting code finished your program should say Grid.Refresh. I would recommend you to collect all grid setting code to separate custom method, e.g. 'ResetGrid', it may include:
With Thisform.Grid1
.Recordsource=""
.Recorsdsource="tablex"
.Column1.Controlsource="tablex.field1"
....
.Columnx.Controlsource="tablex.fieldx"
.Column1.ColumnOrder=....
....
.Columnx.Width=...
.Refresh
EndWith