How prevent form close when 'BeforeUpdate' cancelled

[mscertified]

My form always shows a single record, it has two command buttons Cancel and
Save. When Save is clicked, my BeforeUpdate validations are done and I issue
'Cancel = True', however, the form still closes and the record is saved. What
can I put in my Save button procedure to prevent this? The procedure contains
DoCmd.Close.

Thanks.

 

[George Nicholson]

The procedure contains DoCmd.Close.

DoCmd.Close doesn't belong in cmdSave_Click. Take it out.

Now then, we know when you *don't* want the form to close. When *do* you
want it to close?

 

[mscertified]

I want it to close when the Save button is clicked and the Before Update
event is not cancelled but not when the Before Update event is cancelled.

 

[George Nicholson]

If Not Cancel Then DoCmd.Close

--
HTH,
George

I want it to close when the Save button is clicked and the Before Update
event is not cancelled but not when the Before Update event is cancelled.