Open Access report in separate windows
Posted on 2010-01-03
I have a form displaying a list of reports (one lines corresponds to a Customer Code in the report), when user double click one line or selecte multiple lines, the related reports will be opened in a separate window. And in that window, each report can be exported separately based on the selected Customer code.
I used this query for the report query:
fltSQL0 = "[Customer_CODE] in ('12', '195')"
DoCmd.OpenReport "rptTemplate", acViewPreview, , fltSQL0
But I found the reports for customer code '12' and '195' are in the same page and in the same report. How could I open the report seperately (my purpose is users could save report for '12' and report for '195' separately)?
Access report in seperate windows.
I tried below query, still get the two reports in one page:
fltSQL1 = "[Customer_CODE] in ('12')"
fltSQL2 = "[Customer_CODE] in ('195')"
DoCmd.OpenReport "rptTemplate", acViewPreview, , fltSQL1
DoCmd.OpenReport "rptTemplate", acViewPreview, , fltSQL2
Thanks for the help.