Report Problem

D

DanWH

In my database I've designed in Access 2003, my reports all generate two
copies of each. For example, if a report is 2 pages long, then the report is
actually 4 pages with the last 2 pages identical to the first 2.

This has never been a huge problem for me, but now in a report that I'm
designing, a subreport only appears in the second iteration of the report and
not the first.

Any ideas on what is happening and how to correct it?

thanks
Dan
 
W

Wayne-I-M

This has never been a huge problem for me,

Here is an easy method (there are a few others) of printing multiple copies
of the same report

On you form create an option group with just buttons with the numbers 1 to
10 (or whatever)
In the Data column column make sure the Option Value is the same as the
number
Call the option group "FramePrint"

Create a button with this OnClick
DoCmd.SelectObject acReport, "ReportName", True
DoCmd.PrintOut , , , , Me![FramePrint]

Change ReportName to the name of your report

A good idea is to set the option group to visible = No and the print button
Then on your form on your form just have another button that will change the
visible for both to = Yes. This will stop you form looking to clutered.

Hope this helps
 
D

Dale Fye

My first guess is that the query underlying the main report is returning
duplicate records. Have you run the query separately?

I would resolve this before I try to figure out why it is only filling in
the subform on the 2nd copy of the record.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
Top