Multiple Reports

[Grimwadec]

In Access 2010 I have a Sub-report embedded in a Report. The sub-report works fine. The problem is that if there is 5 records in the sub-report I get 5 versions of the Main Report. My user has a work around, he just tells the printer to print page 1 only. That's coolbut I want to (know how to) fix it. Can anybody help please?

 

[Grimwadec]

Thanks Pat. I Think your suggestion is working but can't be sure because when I open the report, Access cracks a hissy fit and I have to shut it down.

 

[Grimwadec]

In fact I find that when I am able to stop Access from having a fit the report still duplicated

 

[JHB]

What is the record source for the main report, (if a query, show the query string)?
The record source for the main report, must only contain 1 row, else you'll get so many report as row in the record source.

 

[Grimwadec]

In fact I removed the table that was in both queries, and instead populated the fields (that I thought I needed the duplicated table for) using Allen Browne's ELookup

 

[JHB]

I do not know Allen Browne's ELookup, but if you got the report to show what you want, then it is fine!