Msgbox

F

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
 
R

Rick Brandt

Floyd Forbes said:
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....
Click to expand...

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