Option to Halt a Macro?

[ShellyL]

Is there a way to give the user an option to halt a macro? The first step of the macro will be a MsgBox warning “you are about to update…”. Then I’d like a yes/no “are you sure?” box to pop-up. If user clicks no, the macro ends. If yes, it continues. I don’t want the user to have to click ‘no’ through a dozen subsequent warning boxes that Access automatically gives if they initiated the update macro by mistake!

 

[jbpelletier]

you could split it into 2 macros

macro1 call a function that is in a module that show a msg box

if user click yes then call macro 2

jb

 

[ShellyL]

Thanks. I've never worked with modules or any VB before. I was hoping there was a simple macro option somewhere. Oh well.