Linking forms based on two fields

[Tony Williams]

I have a form based on one table that I want to include a subform based on
another table. I know about the parent/child link property but I want to link
the records on the sub form with two controls on the main form so that the
main form data is automatically entered into the corressponding two fields in
the second table.
How do I do this?
Thanks
Tony

 

[PieterLinden via AccessMonster.com]

I have a form based on one table that I want to include a subform based on
another table. I know about the parent/child link property but I want to link
the records on the sub form with two controls on the main form so that the
main form data is automatically entered into the corressponding two fields in
the second table.
How do I do this?
Thanks
Tony

In the LinkChild and LinkMaster fields, enter the field names separated by
semi-colons, like this:

LinkChild Fields: hPatientID;hProtocol
LinkMaster Fields: ePatientID;eProtocolID

 

[Tony Williams]

Thanks Pieter, sounds easy enough.
Tony

In the LinkChild and LinkMaster fields, enter the field names separated by
semi-colons, like this:

LinkChild Fields: hPatientID;hProtocol
LinkMaster Fields: ePatientID;eProtocolID