Aborting an update

[Dmcniell]

Hello and thanks in advance for your help.

I'm trying to do some data validation in the BefureUpdate event of a form, and when I encounter an error, I want to abort the update, show a message box, and return the user to the form.

How do I abort the update within that event?

 

[RoyVidar]

Use:

[tt]Cancel = True[/tt]

Roy-Vidar

 

[psemianonymous]

here's an example of what you might do:
[tt]
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Nz(cboCourse.Value, "") = "" Then
MsgBox "Missing Information: Please select a specific course from the list provided.", vbExclamation
cboCourse.SetFocus
Cancel = True
Exit Sub
End If
End Sub
[/tt]