microsoft.public.access.reports

bw wrote:

>I have a sub-report that prints "exactly" as it should, but then repeats
>many, many times.
>
>The stand alone sub-report prints two pages.
>The sub-report in the main report prints 4226 pages (duplicates of two
>pages, 2113 times).
>The reports are NOT linked.
>The sub-report is located in the Detail section of the main report.
>I select to print this sub-report from a form, and then make the appropriate
>controls visible/not visible depending on the type of report I want. It
>works great, just too many pages on the sub-report. All other main reports
>(as selected from the Form, work fine).


Because the subreport is in the detail section, it should
repeat as many times as there are records in the main
report's record source table/query.

--
Marsh
MVP [MS Access]