Referencing Text Box on Subform

[Luke Bailey]

To reference a text box on a form for a value, you use
something like strMyVal = forms![form 1]![txt MyString].
How do you reference a text box from a subform?

 

[Marshall Barton]

To reference a text box on a form for a value, you use
something like strMyVal = forms![form 1]![txt MyString].
How do you reference a text box from a subform?

The general syntax is:
Forms!mainform.subformcontrol.Form.textbox

Or, from the main form containing the subform:
Me.subformcontrol.Form.textbox

Or, from a subform to its mainform:
Me.Parent.Control.Form.textbox

 

[Luke Bailey]

That's what I needed.

Thanks!

-----Original Message-----

To reference a text box on a form for a value, you use
something like strMyVal = forms![form 1]![txt MyString].
How do you reference a text box from a subform?

The general syntax is:
Forms!mainform.subformcontrol.Form.textbox

Or, from the main form containing the subform:
Me.subformcontrol.Form.textbox

Or, from a subform to its mainform:
Me.Parent.Control.Form.textbox