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)
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
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)
Code:
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