help with stop macro

[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.

 

[bhicks11 via AccessMonster.com]

Did you put your msgbox in the condition column with a STOP MACRO action as
the first line of your macro?

Bonnie
http://www.dataplus-svc.com

 

[dorionsmom via AccessMonster.com]

The message box is the action and stop macro is on the second line...but your
repsonse just made me remember How I did it before...I'm going to try it now..
..I think I know exactly where you're going with this

Did you put your msgbox in the condition column with a STOP MACRO action as
the first line of your macro?

Bonnie
http://www.dataplus-svc.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

[quoted text clipped - 7 lines]

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.

 

[bhicks11 via AccessMonster.com]

Yes that'll work. Capture the response in the message box and if it's no -
run the stop macro.

Bonnie
http://www.dataplus-svc.com

The message box is the action and stop macro is on the second line...but your
repsonse just made me remember How I did it before...I'm going to try it now..
.I think I know exactly where you're going with this

Did you put your msgbox in the condition column with a STOP MACRO action as
the first line of your macro?

[quoted text clipped - 7 lines]