>Hi,
>
>This should be rather simple but I can't figure it out. I have a grid where RecordSource property has a value. Then each column ControlSource has a value (pointing to a field). I need to change the name of the RecordSource (e.g. from "Alias1" to "Alias2"). But when I do it, the values of ControlSource in all columns is blanked. What am I missing?

I think there is a suggestion here using grid builder. Also Dorin V provided a solution a while back, if memory serves. Do a search.

If you try to do this in the properties sheet, it resets it.

BTW, I think I did create a program for safe change and may be posted here.