Linking two sub forms with a form

[HL]

Hi

I have a form with two subforms showing different information.

The main form shows the company details, like company name

The first sub form shows the contacts within the company, the two main fields are company name and surname.

What I would like to do is when I click on a record of the company name and surname in the first subform.

In the second subform, I would like to show all of the correspondence details which has been associated with that surname.

I already have the tables set up and queries set up, I would like to know how to set up the link which will make the two subforms work together.

Cheers HL

 

[arickards]

Insert the subforms into your main form. In the properties of the subform use the link master and link child property and type in the field name you want to link by.

HTH