I am changing the ControlSource of a TextBox at runtime.
Me.Controls("userRecurAD" & ADButChng & "txt").ControlSource = "NewSourceName"
Works great but after the form is closed, and reopened the txtbox.ControlSource = "OldSourceName"
Why are the changes to the control source not saved? How can I save the ControlSource change?