Link Child Field and Master Field

[Guest]

Hello,
I am trying to remember how to link a subform to a form. I believe use child
and master fields but for the life of me I can't remember how to do this. Any
help would be great!

Thanks,

 

[Steve]

Open your main form in design view, select the subform control and open
Properties to the Data tab. LinkMaster should be the Primary Key of the
recordsource of the main form and LinkChild should be the Foreign Key of the
recordsource of the subform.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Guest]

Open the form/subform in design view. Click on menu VIEW - Properties.
Clock on the upper left corner of the subform. The outer edge should
indicate it is selected. Then in the properties window type in the fields
for Child and Master links. They need to be the same datatype but do not
need to have the same name.