To open multi report on Access using DoCmd OpenReport (1 Viewer)

[Nyan Win]

Hi Guys,
I want to open different Access reports by a combobox using DoCmd OpenReport, Opening single report is OK.
But I want for multiple report at the same time. Pls help How can I code for it .

My codes are as follows:
Private Sub cmdOpenReport_Click()
On Error GoTo Err_Process

If (Not IsNull(Me.cboTownship_Name_Eng)) Then
DoCmd.OpenReport "Entry_cost", acViewPreview, , "Township_Code=" & Me.txtTsp_Pcode
Else
MsgBox "You must select a Township." & vbCrLf & vbCrLf & "Please try again.", vbExclamation, "No Township Selected"
End If

Exit_Process:
Exit Sub
Err_Process:
MsgBox "Procedure: cmdOpenReport" & vbCrLf & vbCrLf & Err.Number & " " & Err.Description, vbExclamation, "Error"
Resume Exit_Process

End Sub

 

[arnelgp]

all report is on their Own window:

DoCmd.OpenReport "reportname1"
DoCmd.OpenReport "reportname2"
DoCmd.OpenReport "reportname3"
etc.

 

[pbaldy]

Just add a second OpenReport with a different report specified.

 

[theDBguy]

Pardon me, is this a duplicate post?

 

[Nyan Win]

all report is on their Own window:

DoCmd.OpenReport "reportname1"
DoCmd.OpenReport "reportname2"
DoCmd.OpenReport "reportname3"
etc.

Thanks I just wrote like that, But the code " "Township_Code=" & Me.txtTsp_Pcode " needed for each report and message asks "Enter parameter value" for Township code for each reports. If I want to open 10 reports, I have to reply Township code 10 times. It is tedious. I want to type Township code one time to appear for all reports. Thanks

 

[pbaldy]

If you're getting prompted, either the field name is spelled wrong or that field isn't in the record source of the other report(s).

 

[arnelgp]

I think what you need is multiple Township_code on a report, not multiple report.
instead of Combobox on your Form, replace it with Multi-select Listbox.

 

[Nyan Win]

I think what you need is multiple Township_code on a report, not multiple report.
instead of Combobox on your Form, replace it with Multi-select Listbox.

No, I want to open the different (10)Access reports just after choosing a specific Township code.