Code To Change Form Control Name

[GGleason]

Does anybody know how to change a form control name in VBA? I can find the existing name without a problem, but I don’t know how to change the name of the control. My current syntax that yields a 2467 error is:
[tt]
Me.Controls(strFrmObjNameOld).Name = strFrmObjNameNew
[/tt]
tia,
GGleason

 

[jhall156]

You have to open the form programmatically in design view to change this kind of property, it is read only in form view. JHall

 

[GGleason]

I do the following before trying to name it:
[tt]
DoCmd.OpenForm "Form1", acDesign
[/tt]
but I still get an error. Is there something else that needs to be done?

 

[GGleason]

Nevermind. I got it to work!

Thanks,
GGleason

 

[jhall156]

Where are you executing this code?


Try:
Forms!Form1.Controls(strFrmObjNameOld).Name = strFrmObjNameNew
JHall

 

[GGleason]

As JHall indicated, my problem I was trying to alter the form I was running. The solution was to run the code from another form and it worked.

GGleason