>>>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.
I posted a link to Dorin's code. I know I've done it myself using similar trick - but need to search where did I save that little "grid builder".
However, if you already changed the RecordSource, then you need to manually re-create as they are gone (or open the backup copy of the form).
If it's not broken, fix it until it is.
My Blog