Can I take control of implicit Saves?

[Stapes]

Hi

I am setting up forms for data entry. When the user enters data and
then uses the navigation controls to move on, the record just edited /
added is saved. I want to intercept at this point to ensure that all
the required fields have been entered correctly. Can I do this?

Stapes

 

[Guest]

Put the validation code in the form's BeforeUpdate event procedure. This has
a Cancel argument whose return value can be set to true if the validation
criteria are not satisfied, e.g.

Dim strMessage As String
Dim blnCancel As Boolean

If IsNull(Me.SomeControl) Then
strMessage = "A value must be entered in field X."
blnCancel = True
ElseIf IsNull(Me.SomeOtherControl) Then
strMessage = "A value must be entered in field Y."
blnCancel = True
ElseIf IsNull(Me.YetAnotherControl) Then
strMessage = "A value must be entered in field Z."
blnCancel = True
End If

If blnCancel Then
MsgBox strMessage, vbExclamation, "Warning"
Cancel = True
End If

Ken Sheridan
Stafford, England