B
Bob
This code stops the record from being saved unless OwnerID has data, But if
I open the form later and delete data out of ownerID the record still saves,
Can I get a warning "Caution This Record has No OwnerID"
Thanks for any help.........Bob
--
Private Sub cmdClose_Click()
If IsNull(Me.subHorseDetailsChild.Form.OwnerID) Then
If Me.Dirty Then
Me.Undo
End If
If IsNull(Me.subHorseDetailsChild.Form.OwnerID) Or _
(IsNull(tbName) And IsNull(cbFatherName)) Then
If Me.Dirty Then
Me.Undo
End If
End If
End If
DoCmd.Close acForm, Me.Name
End Sub
I open the form later and delete data out of ownerID the record still saves,
Can I get a warning "Caution This Record has No OwnerID"
Thanks for any help.........Bob
--
Private Sub cmdClose_Click()
If IsNull(Me.subHorseDetailsChild.Form.OwnerID) Then
If Me.Dirty Then
Me.Undo
End If
If IsNull(Me.subHorseDetailsChild.Form.OwnerID) Or _
(IsNull(tbName) And IsNull(cbFatherName)) Then
If Me.Dirty Then
Me.Undo
End If
End If
End If
DoCmd.Close acForm, Me.Name
End Sub