Hi Mike

There have been several threads that deal with re-setting the grid to work with a different cursor, which is something you'd have to do if you had a query as the recordsource and you requeried it.

I haven't had to use a different recordsource with one grid. I usually open the same source per grid. MaxFrame has a method on the grid to remember the grid's settings so they can be restored after requerying a view/SPT.

As to why the textbox has a controlsource, what would it be without one? ;)

>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.
>
>I guess my question should have been:
>a) Why don't the ControlSources for the column stay alive when the RecordSource is changed?
>b) Why is there a ControlSource for the text1 element? Why would an entry ever be needed there?
>
>Mike Smith