In a BeforeUpdate event I check certain conditions and display an error message if they are not met. I then use DoCmd.CancelEvent and get another message box displayed with the text "You cancelled the previous operation".

How can I stop the second message box appearing?

try this

docmd.setwarnings false
docmd.cancelevent
docmd.setwarnings true

tc3of4