SQL Error trapping "Alan Fisher via AccessMonster.com" <u18147[ at ]uwe> 22.02.2006 19:51:54 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200602/1

Re: SQL Error trapping "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> 27.02.2006 05:12:00 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. -- Sylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF "Alan Fisher via AccessMonster.com" <u18147[ at ]uwe> wrote in message news:5c463a4f03d1a[ at ]uwe... [Quoted Text] >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. > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200602/1