Printing multi Reports

[Stemdriller]

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

 

[DCrake]

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.

 

[Stemdriller]

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

 

[DCrake]

    Dim stDocName As String

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

 

[paragk9]

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..!