Validation on form 1

[nycbigapple]

Hi, I am trying to validate a field on a subform, where do I put the validation on the form to prevent the user form leaving the record.

this is what I put on the subform but it goes to next record
Thanks

Private Sub Form_AfterUpdate()
If IsNull(txtCompletedDate) = True Then
    Me.txtCompletedDate.SetFocus
    Cancel = True
End If

End Sub

 

[mp9]

Try it on the BeforeUpdate...

http://www22.brinkster.com/accessory/