Access Report duplicating same record

Question

Hey folks, 

I'm having trouble when I use my form to print a report.

I have it set up so that my form has a print button which prints the current record on the screen. It worked perfectly for a while but then all of a sudden instead of printing one record on one page it is printing the same record on 4 pages. 

I'm not sure what changed as it was working fine earlier.

Any help would be greatly appreciated.

Thanks,

E

Answer 1

It looks from your screen shot that you are not using a bound report. I really have no clue why not. The better way to do this is to bind your report to a query that is based on the Recordsource of your form. Then your print button is simple:

DoCmd.OpenReport "reportname",acViewPreview,,"[keyfield] = " & Me.keyfield

Whenever you ask a question that involves code being run, you need to show us the code you are using, Without seeing the code its hard to diagnose he problem. Or you can follow my suggestion on how to set up the report and the button.

Answer 2

Is your report based on a Record Source? Have you looked at the record source to see how many records is returns?

Do you have code that filters the report?

What is the code behind the print button?

Answer 3

What is the RecordSource for the report? It should be blank in this case.

Answer 4

Unfortunately due to the nature of the form I cannot. However, I can post a couple of pictures of the form and report itself

Answer 5

To provide the most helpful answer, some more information is needed.

Would you be able to save a copy of the file without any sensitive data to OneDrive, Google Drive or Dropbox and post the link to the file as a reply.

Thanks.