Reference to Control on Nested Subforms - My brain is going to explode!

[Elana]

I have a tab control as my main form and then I have a subform which itself has a subform to pull another level of information. I am having trouble figuring out how to refer to a control on the nested subform. I have this so far:

Names of forms/controls: frmMain, frmSub1, frmSub1A (control on frmSub1A is named cmbContactID).

To refer to control cmbContactID I've tried everything, but I thought this would be right:

forms!frmMain!frmSub1.form!frmsub1A.form!cmbcontactID

I still get #Name? as a result. Any guidance is much appreciated!

 

[not_rich_yet]

Try using the expression builder as this cannot get the names wrong...all those !!! and [][][] get me confused with nested nested stuff!

nry

 

[Elana]

I figured it out -

forms!frmMain!frmSub1!frmsub1A.form!cmbcontactID

EB