Forms Master & child issue

[rexb]

Hi,

Happy New year to all!

Thanks so much for all the help I get from this forum. Again I'm back to ask questions Here goes....
First I have a Main form where I want to put 2(two) subforms, I want to relate the 1st form to the main form and the 3rd form to the 2nd form the catch is I want to have both forms on the main form. How do I do the master/child relationship here? I was able to connect the 2nd form to the main form but I can't do it on the 3rd form. Any suggestions?

Thank you in advance for any help. It is very much appreciated.

 

[dcb]

Would suggest you create a "unseen" version of form 2 that contains form 3
or leave form 3 Unbound (in relation to the others) and use VBA to control it and/or let it fetch data from form 2.
I am hoping someone else has a better method though...!

 

[CraigWarmy]

Have you ever thought of having a unique value in form #2 and then link it to the form #3 using the link master/link child form properties? Also do the linking in the relationship window. Might have to add some code also.

 

[Galaxiom]

A master child relationship can cross into subforms.

SubformcontrolB properties:-
Master Link Fields: subformAcontrolname.Form!somefield
Child Link Fields: anotherfield

 

[rexb]

thanks for all your help. was able to figure it out.