>>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.
I think just for this grid I will have to reenter all values in ControlSource manually, rather than making a builder. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham