Link Subform to subform within another subform

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

I have a mainform that has subform1. Subform1 has 2 subforms, subform2 and
subform3. How do I link subform2 to subform3 using ManyID as the link
between them? I don't know how to reference the control ManyID in subform2
from subform3. Any ideas?

Thank you,
Sarah
 
Sarah said:
I have a mainform that has subform1. Subform1 has 2 subforms, subform2 and
subform3. How do I link subform2 to subform3 using ManyID as the link
between them? I don't know how to reference the control ManyID in subform2
from subform3.
Click to expand...


I have heard that you can set subform3's LinkMaster Fields
property to this kind of thing:
Forms!mainform.subform1,Form.subfomr2.Form.ManyId
bu I have never been able to make that work.

I add a hidden text box to subform1 and use subform2's
Current event to set it:
Parent.hiddentextbox = Me.ManyId

Then set subform3's Link Master to hiddentextbox
 
Thanks Marshall. That worked.

Marshall Barton said:
I have heard that you can set subform3's LinkMaster Fields
property to this kind of thing:
Forms!mainform.subform1,Form.subfomr2.Form.ManyId
bu I have never been able to make that work.

I add a hidden text box to subform1 and use subform2's
Current event to set it:
Parent.hiddentextbox = Me.ManyId

Then set subform3's Link Master to hiddentextbox
Click to expand...
 
Back
Top