SQL Error trapping

  • Thread starter Thread starter Alan Fisher via AccessMonster.com
  • Start date Start date
A

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.
 
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.
 
Back
Top