Macro Problem

J

Janet

Hello,

I have a macro which running a report attached to a
parameter query. The macro is attached to a command
button on a form, and after I enter my criteria into the
parameter value msg box (which pops up when I hit the
command button), the macro then sends the report to Word
(the macro reads as follows:
Open Report
Run Command (this is OutputToRTF)

The problem is that if I choose to hit "Cancel" instead,
it still continues to send the information to Word. How
can I stop this from happening? Thank you.

Janet Friesen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top