How to close report with message if "run-time error '2427' comes up

D

doyle60

I get the run-time error '2427' error with the message "You entered an
expression that has no value" when I run a certain report. The query
is already difficult enough. I'd rather just interrupt the message
and insert my own message stating "You did not hit the Set Comparison
button" and have the report close down completely. The error is due
to something in a subreport.

Someone gave me code to do something like this before but I have no
idea where in my database it is. It's pretty big at this time.

Thanks,

Matt
 

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