msgbox

[accessman2]

In MS Access,

MsgBox "Are you sure", vbOKCancel

and there is OK , and Cancel buttons.

I want to do that if click "OK", then run the action, if click "Cancel", then cancel the action.

eg.
MsgBox "Are you sure", vbYesNo
If (vbYesNo = 1) Then
// run the action
End If

So, how do I edit it?

Thanks.

 

[yellow]

If MsgBox ("Are you sure", vbYesNo) = vbYes then
action
Else
OtherAction
End If