multiple reports printing as 1 report

[brad6582]

I created a program that a user can fill out then choose what reports they want to print out using check boxes. All the reports with a checkmark print, but they print as single document rather then one report. I am trying to have all the choosen reports print as 1 report rather the seperate.

 

[Khalid_Afridi]

I created a program that a user can fill out then choose what reports they want to print out using check boxes. All the reports with a checkmark print, but they print as single document rather then one report. I am trying to have all the choosen reports print as 1 report rather the seperate.

What code you are using to print the chosen reports? What reports do you want to print? May be you want to make a criteria based on the check boxes checked and then make a query for a single report to print....

 

[brad6582]

I am actually not using code to have these print. I am using a macro that I set up that useres a "where condition" to pull the checked reports. I just want the reports the user checks to be on 1 report rather then multiple reports it does right now.

 

[Khalid_Afridi]

You mean you just want to print all the reports in one goal? if you design all the reports each for separate purpose then it should be printed separately, however you can print all the report check by through VBA code:

Private Sub cmdPrint_Click()
    If Me.Check0.Value = 1 Then
        DoCmd.OpenReport ("report1"), acViewNormal
        If Me.Check1.Value = 1 Then
          DoCmd.OpenReport ("report2"), acViewNormal
        End If
    End If
End Sub

 

[brad6582]

Cant seem to figure it out for some reason. Its been awhile since I have been in access so really rusty on things. Do you have an email I can send you a couple screen shots?
Thanks for your time

 

[Khalid_Afridi]

Cant seem to figure it out for some reason. Its been awhile since I have been in access so really rusty on things. Do you have an email I can send you a couple screen shots?
Thanks for your time

you can attach your screen shots here also by clicking on advance button below this post and then by clicking on Manage Attachments...

 

[vbaInet]

I am trying to have all the choosen reports print as 1 report rather the seperate.

You built your reports as separate report objects so they will print as separate reports. It's like saying I created 3 word documents and I want to print them as one. What do you do? You manually merge the documents before printing.