I have a form (1) that contains a sub-form (2), a sub-sub-form (3), and a sub-sub-sub-form (4).
I need to reference the value in a field (is this also called a control??) on (3) as a criteria in the query behind (4). I tried the Me.Parent!ControlName nomenclature (Me.Parent![PartNumber]), but I'm not getting any effect,
Is there a way to use some sort of relative reference for the query criteria behind (4)?