How to open multiple instances of a report

[snoopy22]

Hi everyone.

I'm kind of a novice in VBA so have mercy
My problem is this: I've got one report that needs to be open multiple
times, each time for different person. In other words i think i need to
create multiple instances of this report.

this is my current code:
(Imagine i've got a loop that repeat this code for each person)

DoCmd.OpenReport "rptTransaction", acViewPreview

right now, only one report is opening (for the first person), I've done some tracking to isolate the problem, and i've found that if the current report is alreadyopen, then it igonres my request to open it again for the second person and so on...
what should i do?

Ofir

 

[ghudson]

You just need to add some "criteria" to the SQL [data source] of the report to filter out the users records. Do not create a new report just for a specific user.

 

[modest]

Correct, and I do not believe you are able to open the Print Preview of a report more than once. In order to "update" the data the way you are saying, you will need to close the window first, then re-open the report.