Perform simple data validation checks when editing a record in a form
Use the BeforeUpdate event of a form or a control to perform validation checks on data entered into a form or control. If the data in the form or control fails the validation check, you can set the BeforeUpdate event's Cancel argument to True to cancel the update.
The following example prevents the user from saving changes to the current record if the Unit Cost field does not contain a value.
Private Sub Form_BeforeUpdate(Cancel As Integer)
' Check for a blank value in the Unit Cost field.
If IsNull(Me![Unit Cost]) Then
' Alert the user.
MsgBox "You must supply a Unit Cost."
' Cancel the update.
Cancel = True
End If
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for