my macro just keeps running

  • Thread starter dorionsmom via AccessMonster.com
  • Start date
D

dorionsmom via AccessMonster.com

I created a Macro on a command button (Print Report). However, I don't want
the report to open if the date field on the form is blank. SO far it's works
by checking to see if the control is null and if so i have a msg box that
tells the user to enter a valid date. (I'm using a calendar activex control
for that so I won't have any issues with formatting)

here's the problem though....if the date is null the msg box appears but once
you click ok the macro keeps running and opens the report anyway...

Please help! I tried so many things...I had this problem before about a year
ago but I can't remember what I used to get around it.
 
S

Steve Schapel

Dorionsmom,

If you could let us know the details of the macro as you have it so far,
somebody may be able to spot the problem.
 

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