Originally Posted by
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 2nd 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