Link to home
Start Free TrialLog in
Avatar of Ken Milam
Ken MilamFlag for United States of America

asked on

Relative reference for sub sub sub from?

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)?

Thanks,
Ken
ASKER CERTIFIED SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ken Milam
Ken Milam
Flag of United States of America image

ASKER

Thanks, John,
So, what if I want to open a certain form combination where [Part Number] = 1234.  

I've got a button on an action button on form (Form_Select] that I'll use to open another form (Form 1] that will contain three nested sub forms

Form 1
 Sub Form 2
  Sub Sub Form 3
    Sub sub sub Form 4

Form 4 contains a control [PartNumber].  

I want to click a button on [Form_Select] to open [Form 1] the where PartNumber = 1234 on [Sub sub sub Form 4].


DoCmd.OpenForm "Form1", , ,"what goes here?"  


Thanks,
Ken
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image
I you can share a sample i think it would most helpful