I have a data file TRANSACTIONS1 that is handled with a Grid called Grid1.

I would like to be able to use the same Grid to handle a file of same structure TRANSACTIONS2.

I constructed Grid1 to make no reference to the data file in the ControlSource property for each column. e.g. instead of calling the ControlSource Transactions1.Price, I just called it Price.

I then saved Grid1 and Grid2 and changed the RecordSource to TRANACTIONS2, I then found that the RecordSources for each column had disappeared.

Is there some way of constructing a Grid so that it can be modified to handle a different RecordSource without having to retype all the ControlSources for each Column?

Mike Smith