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?

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