I need to print off 3 reports, rptMechanical, rptElectrical and rptCommercial, from a Form all linked via a Contract Number.

Could someone kindly help with the vba?

Thanks

Gareth

Try placing a button on a form and choose open report and go through the wizard. Then triplicate it on the on click command of the button.

But that prints all the contracts, I need the current one printing only

Dim stDocName As String

stDocName = "YourReportName"
DoCmd.OpenReport stDocName, acNormal, , "[YourField]=" & SelectedCustomerID

Hey Boss,
I am not that good programmer to suggest, but you can do one thing.

You can create a macro having print action for all reports. You can give a condition of specific contract no or so in a query generating reports.

It should work, as it worked with me smoothly,

Thank you,

Paragk9..!