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
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
Microsoft Access
Last Comment
John Tsioumpris
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I you can share a sample i think it would most helpful
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