Referring to controls

  • Thread starter Thread starter a
  • Start date Start date
A

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)?
 
a said:
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)?
Click to expand...

Me.Parent!ControlName
 
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)?
Click to expand...

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
 
Back
Top