pungentSapling
NeedHotSauce?
- Local time
- Yesterday, 23:23
- Joined
- Apr 4, 2002
- Messages
- 115
I have the following for next loop to open a report(s).
code:
For i = 0 To iac
DoCmd.OpenReport "rptMain2", acViewPreview, , "qryGetSelectedAddress.[recID] = " & intID(i)
Next i
end code:
The idea is to create an instance of the report for each address the user has selected..... This works fine when I use acNormal as the view but when I use preview it only opens the first one. This is causing problems becuase I have some code in the report_activate event that calls the print dialog box (so I can print to file for making pdf). I guess the second...third...etc instances of the report are not getting activated when using acPreview.
How can I force the other insatnces of the report to be visible in acPreview and hence trigger the on activate event?
I need the print dialog box to come up for each report also
Thanks
p
code:
For i = 0 To iac
DoCmd.OpenReport "rptMain2", acViewPreview, , "qryGetSelectedAddress.[recID] = " & intID(i)
Next i
end code:
The idea is to create an instance of the report for each address the user has selected..... This works fine when I use acNormal as the view but when I use preview it only opens the first one. This is causing problems becuase I have some code in the report_activate event that calls the print dialog box (so I can print to file for making pdf). I guess the second...third...etc instances of the report are not getting activated when using acPreview.
How can I force the other insatnces of the report to be visible in acPreview and hence trigger the on activate event?
I need the print dialog box to come up for each report also
Thanks
p
