Changing ControlSource

[Rick]

I have a form with a text box (txtInputBy) whose control
source I set with:
msg = InputBox("Input by?")
msg = "=" & "'" & msg & "'"
Me!txtInputBy.ControlSource = msg
Another bound control uses this value to store with other
data. This allows me to change the Input by data in form
view. However this control source is not saved when the
form is saved and closed. If I do the exact same thing in
the porperty sheet it is saved. I need the Input by value
to remain the same until I want to change it. Do I need to
use another method to do this or am I just doing something
wrong? I don't have to have the code switch the form to
design view, do I?

Thanks.

Rick