When printing a report it duplicates

[Gadgets]

I have a database that I am creating for a client, when I click on print and it brings up the report, the report is duplicated depending on the length. The report contains subforms that can have unlimited records. I hope this makes sense to you.

Thanks.


Chad.

[June7]

The subreport in Detail section? The subreport would print with each record of the main report.

[Gadgets]

When I click on the button that I created "Print Record" is replicates the same report in there up to 42 pages not 4 pages like it should be.

Maybe I did the event wrong, I am not sure.

The envent looks like this.

Private Sub cmdPrint_Click()
Dim strWhere As String
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to print
MsgBox "Select a record to print"
Else
strWhere = "[ID] = " & Me.[ID]
DoCmd.OpenReport "Report1", acViewPreview, , strWhere
End If
End Sub

[June7]

Code looks fine. Without knowing more about db structure and report design, can't advise further.

If you want to provide db for analysis, follow instructions at bottom of my post.

Also, learn debugging. Refer to link at bottom of my post for debugging guidelines.

[Gadgets]

Here is a copy of the DB.

Thanks for checking it out.

[June7]

Don't include Equipment table in the main report RecordSource.

Why do you have Print Record and Print Report buttons?

In Relationships - Employee table should not be joined to Invoice table.

The fields named LaborID, EquipmentID, MaterialsID should be named something like Labor_InvoiceID_FK, Equip_InvoiceID_FK, Mat_InvoiceID_FK.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention.

[Gadgets]

I removed the relationship with employee table and invoice table.
The Printer record was just a test, I thought that I took it out.

I am not sure of what you mean by "Don't include Equipment table in the main report RecordSource."

[June7]

The main report RecordSource query has two tables joined. Remove Equipment table from the query.

[Gadgets]

What is the best way to build the report for this? Would you pull the subform into the report? or ?

[Gadgets]

The main report? Is that my "Report1" I guess I am not sure what you are saying.