>Mike:
>
>OK, I didn't know that part.
>
>But what I have been finding is that if I attempt to reuse a Grid with a different Data File, the ControlSources for the Columns all go blank but the ControlSources for Text1 elements remain intact.
>
>In this case I had built the original grid without a reference to the actual data source e.g. the ControlSource would be called "Price" rather than "Trans1.price".
>
>I thought this would make it easier to adapt it for my cursor "Trantemp" but no way because the ControlSources for each column all evaporate when the RecordSource for the Grid is changed. But the ControlSources for Text1 of each column stay alive where they are useless.

My trick to swap tables under the grid is to have a readwrite cursor for its recordsource. Then when I need to use a different set of data, I zap this cursor and append new data into it. The grid remains intact and I have no problems.