Simply open three reports on single clik in form (1 Viewer)

[sumox]

I'VE objects in ACC2003 as per following :
Form name : INVOICECreate
Query Name : db_InvoiceSet
Reports :
1st Report : Report_Inv1
2nd Report : Report_Inv2
3rd Report : Report_Inv3

All Reports based on Single db_InvoiceSet due to some cross
and different manipulation of data for different office department

So, I need is:

Open All Reports in Print Preview Mode with Single Click of Button in Form
INVOICECreate

Thanks in adv

Level of VBA Knowledge: Beginner .

 

[sumox]

another question also.

do query fetch data simultaneously to all reports ?

is there any solution.

do i need to copy queries ?

 

[namliam]

You can simply create 3 lines of
Docmd.Openreport

And no, queries do not fetch data simultaneously, they do so in Sequence.
So first report1 will open and fetch data,
then report2, etc.