Referring to controls

[a]

Thank you

How can I refer to (subform) from (subform) on the main form?

How can I refer to (subform) from (masterform)?

How can I refer to control on (master form) from (subform)?

 

[Stuart McCall]

Thank you

How can I refer to (subform) from (subform) on the main form?
Me.Parent!OtherSubformName.Form


How can I refer to (subform) from (masterform)?
Me!SubFormName.Form


How can I refer to control on (master form) from (subform)?

Me.Parent!ControlName

 

[Minton M]

Thank you

How can I refer to (subform) from (subform) on the main form?

How can I refer to (subform) from (masterform)?

How can I refer to control on (master form) from (subform)?

1. Me.Parent.SubformName2.Form will get you to the second subform from
a subform sharing the same main form.
2. Me.Parent.Form.
3. Me.Parent.Form.ControlName from the subform within the master form.

The liberal use of Me, Parent, Form and Subform name should help you
navigate around.

-- James

 

[George Nicholson]

Here's a pretty good set of tables with various permutations:

Forms: Refer to Form and Subform properties and controls
http://mvps.org/access/forms/frm0031.htm