Report with Subreport problem

[Lucy02]

Hi,

I have created a report which shows enquiries made by different companies. Some companies have made 3 different enquiries which the report shows. I have also entered a sub report into this report which shows a summary of the contact that has been made by myself to the matching companies. However instead of just showing one summary of the contact it shows a summary for EACH enquiry record under one company. How do i stop this????

Thanks in advance

Lucy

 

[llkhoutx]

The Master/Child properties of the subreport are incorrect or not set.

 

[Lucy02]

Hi, thanks for this. What should this be set to or how do i set this? Sorry i'm still quite newbieish!

Thanks

Lucy

 

[llkhoutx]

Look at the properties for the subform. The Link Master Fields property is one or more primary keys on your main form, separated by semi-colons. The Link Child Fields are corresponding primary key(s), whether one or more and also separated by senmi-colons, for the subform.

A record change is the main form, will then tumble the subform to the related record, if any.

Build a test form and subform to try it one. When I first started with Access, I struggled with this.