Substitude a error message with a MsgBox

Hello all

I am trying to make this 'error' message go away and display my own
MsgBox. I have set some of the fields in one of my tables to Required.
And when I am actually interacting in the form and i dont fill that
required field it popsup this 'error' message saying "The field 'xxx'
cannot contain a Null value because the Required property for..." I
want this message to be substitude by my on MsgBox. How do I do that?

Thanks in advance

Generally, you should use code in the Form_BeforeUpdate Event to perform all
data validation before actually trying to save the Record.

Check Access VB Help on the BeforeUpdate Event of the Form object. There is
a sample code in Help also.

--
HTH
Van T. Dinh
MVP (Access)



"erick-flores" wrote in message
oups.com...
Hello all

I am trying to make this 'error' message go away and display my own
MsgBox. I have set some of the fields in one of my tables to Required.
And when I am actually interacting in the form and i dont fill that
required field it popsup this 'error' message saying "The field 'xxx'
cannot contain a Null value because the Required property for..." I
want this message to be substitude by my on MsgBox. How do I do that?

Thanks in advance