Errors reported by SQL to Access

[Jess]

I have an access interface talking to a SQL server database through an ODBC
driver. Data integrity is implemented in SQL. Every time there is a data
integrity violation, SQL reports it to Access which displays an error
message. I can trap this error with the form_error event. However I can’t get
the error message turned off. Is there a way to prevent these errors
messages from popping up? I would like to catch them with code

Thanks

 

[Alex Dybenko]

Hi,
you can use form's beforeupdate event to check entered data against other
tables and cancel event if validation fails

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com