How can I reference a control using a string that contains the control's name?

[Brad Marshall]

I want to set a value in a text box control on a form in VB code. I have a
string that contains the control name. This works:

Me.("ControlName") = "Control Value String"

Great! But now I want to reference a control on another open form. This
doesn't work:

Form_Other.("ControlName") = "Control Value String"

How can I establish a reference to a control on another open form whan I
have a string that contains the name of the control?

Thanks. Brad Marshall

 

[Sandra Daigle]

Try this:

Forms!Form_Other("ControlName")

or

Forms!Form_Other.controls("ControlName")

 

[Graham R Seach]

Brad,

Forms!frmOtherForm(strControlName)

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Brad Marshall]

Oh, the sweet feeling of success. This works:
Forms!Form_Other("ControlName")

Thanks Sandra,

Brad

Try this:

Forms!Form_Other("ControlName")

or

Forms!Form_Other.controls("ControlName")

--
Sandra Daigle
[Microsoft Access MVP]
For the benefit of others please post all replies to this newsgroup.

I want to set a value in a text box control on a form in VB code. I have
a string that contains the control name. This works:

Me.("ControlName") = "Control Value String"

Great! But now I want to reference a control on another open form. This
doesn't work:

Form_Other.("ControlName") = "Control Value String"

How can I establish a reference to a control on another open form whan I
have a string that contains the name of the control?

Thanks. Brad Marshall