Msgbox

[Floyd Forbes]

I'm trying to setup a msgbox for a append query and a delete query behind a
command button.
How do I set up my Msgbox to cancel out if i select cancel.. If I select
OK, I want it to resume, which it does automatically, but if I select cancel
I want it to cancel the operation....

Floyd

 

[Rick Brandt]

I'm trying to setup a msgbox for a append query and a delete query behind a
command button.
How do I set up my Msgbox to cancel out if i select cancel.. If I select
OK, I want it to resume, which it does automatically, but if I select cancel
I want it to cancel the operation....

If MsgBox("Are you sure?",vbOkCancel) = vbOk Then
'Do some stuff
End If

 

[Floyd Forbes]

Thank you!

behind

If MsgBox("Are you sure?",vbOkCancel) = vbOk Then
'Do some stuff
End If