Referring to a field in an open form (sub form in a sub form)

[Ant_Snell]

In a query I want to refer to a field in an open sub form. I have done this many times using [Forms]![MAIN FORM NAME]![SUB FORM NAME].[Form]![FIELD NAME] however this time I want to drill down to a sub form within a sub form. If I use the Expression Builder, it does not show the 2^nd sub form. I have tried typing:
Forms![frm_Index_MyDetails]![frm_Emp_MyDetails]![frm_Emp_MyAbsence].[Form]![Emp_Absence_ID]
With the error message. The expression you entered has invalid .(dot) or ! operator or invalid parentheses.
Therefore my question is how do I refer to a field in a sub form within another sub form? Thanks

[mike60smart]

Hi Ant

You can use this:-

[Forms]![MAIN FORM NAME]![SUB FORM1 NAME]![SUB FORM2 NAME].[Form]![FIELD NAME]

[Bob Fitz]

In a query I want to refer to a field in an open sub form. I have done this many times using [Forms]![MAIN FORM NAME]![SUB FORM NAME].[Form]![FIELD NAME] however this time I want to drill down to a sub form within a sub form. If I use the Expression Builder, it does not show the 2^nd sub form. I have tried typing:
Forms![frm_Index_MyDetails]![frm_Emp_MyDetails]![frm_Emp_MyAbsence].[Form]![Emp_Absence_ID]
With the error message. The expression you entered has invalid .(dot) or ! operator or invalid parentheses.
Therefore my question is how do I refer to a field in a sub form within another sub form? Thanks

The following site may be of interest: http://access.mvps.org/access/forms/frm0031.htm

[Ant_Snell]

Thanks Bob a few things there to try

[Bob Fitz]

Thanks Bob a few things there to try

Post a copy of the db if you still can't get it working.

[Welshgasman]

Hi Ant

You can use this:-

[Forms]![MAIN FORM NAME]![SUB FORM1 NAME]![SUB FORM2 NAME].[Form]![FIELD NAME]

Actually NOT the subform name, but the subform CONTROL name. Not even sure that above is correct?, I would have thought the .Form element would be in there somewhere?
Cannot test as on phone. Bob's link should set you right anyway.

[mike60smart]

Sorry my mistake

[Forms]![MAIN FORM NAME]![SUB FORM1]![SUB FORM2].[Form]![ControlNAME]

[Welshgasman]

Sorry my mistake

[Forms]![MAIN FORM NAME]![SUB FORM1]![SUB FORM2].[Form]![ControlNAME]

Still got it wrong Mike?

Me!Subform1.Form!Subform2.Form!ControlName

For these examples:
Mainform is the name of the top level form
Subform1 is the name of the subform CONTROL on mainform
Subform2 is the name of the subform CONTROL on the 1st subform.

[mike60smart]

Hi WGM

You are correct going by the Forms Reference link.

Me!Subform1.Form!Subform2.Form!ControlName

[Welshgasman]

Hi WGM

You are correct going by the Forms Reference link.

Me!Subform1.Form!Subform2.Form!ControlName

That is where I copied that text from?
Think about it, for one subform control you have to use subformcontrol!Form!Controlname, so you are just doubling up.
The second subformcontrol is still just a control, then you need it's Form, and then the controlname on that subform.

All about hierarchy.