I am trying to use the message box to help control events in code. For example a user will click on a button on a form to update a table. If I use MsgBox and select the vbOKCancel as the type of buttons to show on the message box why is it that when a user selects Cancel the update routine does not cancel? Thanks for any advice!

Please post the code you are using.

I got inspired by thinking of my code overnight. Today I tried this and it seems to work! Thanks for your time charityg!

If MsgBox("Do you wish to transfer this Writ to the Civil Process Table?", vbOKCancel, "Transfer of Writ to Civil") = vbCancel Then
MsgBox "This update has been canceled", vbInformation, "Transfer of Writ to Civil"
GoTo WritTransfertoCivil_Exit:
End If