J
Janet
Hi there,
I have a parameter query which runs a report. On my
form, I have a command button which has a macro attached
to it. That macro pops up the parameter query question
in a msg box, and after I've typed in what I want, it
automatically exports it to Word (macro is as follows:
Open Report
RunCommand
The Run Command is OutputToRTF.
If I choose "cancel" or try to close the msg box because
I don't want to run the report, the macro exports the
data to Word anyway. How do I get the "Cancel" to work?
I have a parameter query which runs a report. On my
form, I have a command button which has a macro attached
to it. That macro pops up the parameter query question
in a msg box, and after I've typed in what I want, it
automatically exports it to Word (macro is as follows:
Open Report
RunCommand
The Run Command is OutputToRTF.
If I choose "cancel" or try to close the msg box because
I don't want to run the report, the macro exports the
data to Word anyway. How do I get the "Cancel" to work?