form before_update event is not firing

[ToyFox]

The before update event in my form is not firing.

This is the code.

If Me.txtStatus = "Completed" Then
If Len(Trim(Me.txtComplete)) = 0 Then
MsgBox "You must enter the complete date"
Cancel = True
Undo
End If
End If

 

[PHV]

Replace this:
If Len(Trim(Me.txtComplete)) = 0 Then
with this:
If Trim(Me!txtComplete & "") = "" Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ToyFox]

Thank you

Works much better.