Soundsmith
Programmer
I have the following code in a cmd button. I want the user to preview the report, optionally print it, and then have the option to delete the records involved.
The preview appears, then the dialog appears over it, and the user never gets the chance to print the report.
How can I make the preview modal? The form it is called from is not a modal screen, nor do I wish it to be.
Thanks.
David 'Dasher' Kempton
The Soundsmith
Code:
dim delXcpt
DoCmd.OpenReport "rptMONRExcept", acViewPreview
delXcpt = MsgBox("OK to delete ?", vbQuestion + vbYesNo)
The preview appears, then the dialog appears over it, and the user never gets the chance to print the report.
How can I make the preview modal? The form it is called from is not a modal screen, nor do I wish it to be.
Thanks.
David 'Dasher' Kempton
The Soundsmith