BeforeUpdate Event msgbox suppressing

[jevans]

Hello Everyone,

I have a form that prevents updating unless certain fields are completed. Here's my problem; I have a Cancel button which actives the msgbox in my BeforeUpdate event before the form closes. Can I suppress this msgbox form opening?

 

[Travis]

Declare a form level variable as boolean

On the Click event of the Button set the Variable = True

Before your message check the variable

if = False do the message box
if = True Exit Sub