On The field <name> cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field. (Error 3314)
I created a custom error message to replace the access error message above. See code below, First a trap error 3314 and my custom message appears but then the standard Access 3314 error message also appears right after.
How do I prevent the Access message.
What code is needed - Where do I put code and in what event.
this is my code in the form in the ON error event
Private Sub Form_Error(DataErr As Integer, Response As Integer)
Const conErrDataValidation = 3314
Select Case DataErr
Case conErrDataValidation, conErrDataType
MsgBox "You must enter a participant status"