How to trap the Database Error and substitute it with the Mesgbox

try the before_update event of the form, or the OnError event also. <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

Thanks <br>I tried both but the the error is raised by the MSSQL server.&nbsp;&nbsp;MS Access Forms I have developed has been based on the MSSQL linked tables.&nbsp;&nbsp;The errors are ODBC connection failed and cannot insert null value.&nbsp;&nbsp;<br>&nbsp;&nbsp;The mesages which I put are dispalyed but the the system errors continue to appear afterwards befor the form is closed and I am afraid it can be confusing for the back end user.&nbsp;&nbsp;If you have delt with similar problem Can you give me more specific way to trap the error and sbustitue it with the meseage I want the user to see.<br><br>Ragards

There is a FAQ on this. I don't know if there is something special or different about an ODBC error, but this works for other error types. Go to the Access: General discussuib forum at this site, click on the FAQ tab at the top of the page, and look at: <br><br>&quot;VBA and Custom Functions&quot; category,<br>&quot;.Basic Error handling - hide an Access error message or substitute your own&quot;<br><br>If this doesn't work, please post yur problem/solution here, we can then incorporate it into the FAQ.