>I have a form with a bunch of textboxes layed-out kind of like a spreadsheet. Don't ask me why they didn't use a grid. I am modifying an existing form.
>
>On my form I have for example -
>
>Name = txtMyTextbox1, ControlSource = Person1
>Name = txtMyTextbox2, ControlSource = Person2
>
>And a command button -
>THISFORM.txtMyTextbox1.ControlSource = Person1
>THISFORM.txtMyTextbox2.ControlSource = Person2
>THISFORM.Refresh
>
>What I want to do is have another command button that does the following -
>THISFORM.txtMyTextbox3.ControlSource = Person3
>THISFORM.txtMyTextbox4.ControlSource = Person4
>THISFORM.Refresh
>
>But I want to rename txtMyTextbox1 to txtMyTextbox3 and also rename the ControlSource from Person1 to Person3. Like-wise for txtMyTextbox2. How can you rename the name of the objects when the form is already displayed using the command buttons to switch the objects names back and forth between two different sets of names?
>
>TIA!!!
I don't ask you why :) Name property is read&write. Causes that may result are up to you (like something referencing the old name).
Cetin