MS Access 2007/2003 - Referencing a control on a sub form, from the parent form

Question

So if I want to reference a control (like a text box) on a sub form, from the CBF of the parent form, how should I do this?

me.SubForm.SubControl

Gives me an error.

Fionnuala · Accepted Answer · 2010-07-01 20:22:05Z

4

Me.SubformControlName.Form.SomeControl

Be sure to use the name of the subform control, not the form contained - they are often the same, but not always.

answered Jul 1, 2010 at 20:22

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

For those who use ! instead of . that would be Me!SubformControlName.Form!SomeControl.