Link subform field to master form

[k7i5t3n]

I have created a master form A which contains subform B and subform C.
They are synchronized, not nested. I have put an unbound text box on
master form A and have tried all sorts of references to link the box to
the primary key of subform B so that I can set child link field on
subform C equal to the text box and therefore relate the two subforms,
but my references aren't working for some reason. The text box field
keeps showing "#Name?"... What does this mean I'm doing wrong???

Thanks.
Kristen

 

[Rick Brandt]

I have created a master form A which contains subform B and subform C.
They are synchronized, not nested. I have put an unbound text box on
master form A and have tried all sorts of references to link the box
to the primary key of subform B so that I can set child link field on
subform C equal to the text box and therefore relate the two subforms,
but my references aren't working for some reason. The text box field
keeps showing "#Name?"... What does this mean I'm doing wrong???

Thanks.
Kristen

=SubformControlName.Form!PKFieldName

Note the use of the .Form and the fact that you first reference the name of the
subform CONTROL which might not be the same as the form displayed inside it.

 

[k7i5t3n]

Thanks Rick... I think I'm confusing the words here... ok, this is what
I'm working with:

Master form name: frm_Test
text box field on master form: Text77

Subform name: frm_Warranty_Issues
text box field on subform that I want to link Text77 to:
txt_Warranty_Issue

So, how would it read? Thanks!

 

[k7i5t3n]

AHA! I see what you're saying. It works now!!! Thanks so much!!