Link to home
Create AccountLog 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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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