R
Ray Todd Jr
I have a form that is used for data entry. One of the fields is a required
field. If I tab through the field everything is ok, however, after you try
to tab through the last field, access attempts to save the record. I get the
following error (because the required field is null due to not being filled
by the user).
The field cannot contain a null value because the required property for this
field is set to True. Enter a value in this field (Error 3314).
Where and how do I attempt to trap this error so that I can give the user a
more pleasant and understanding of the error and how to resolve the issue.
Would I attach error trapping to the before update of the field in question?
Any help and suggestions appreciated.
Thanks,
Ray.
field. If I tab through the field everything is ok, however, after you try
to tab through the last field, access attempts to save the record. I get the
following error (because the required field is null due to not being filled
by the user).
The field cannot contain a null value because the required property for this
field is set to True. Enter a value in this field (Error 3314).
Where and how do I attempt to trap this error so that I can give the user a
more pleasant and understanding of the error and how to resolve the issue.
Would I attach error trapping to the before update of the field in question?
Any help and suggestions appreciated.
Thanks,
Ray.