Link Subform to subform within another subform

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
 
M

Marshall Barton

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.


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
 
S

Sarah

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top