SQL Error trapping

[Alan Fisher via AccessMonster.com]

I have a column that does not allow nulls and it works just fine. When a user
trys to enter a new reccord and leaves the field blank they get an error.
How do I trap the error from the server so I can write my own message and
perform vba code once the user acknowleges the message.
Thanks.

 

[Sylvain Lafontaine]

The easiest way would be to make the verification before trying updating the
database: use the Form_BeforeInsert event and cancel the insertion if a
required field has been left blank.