Hello,

I have always a problem whe the users tried to update a table and when they violate a database rule (unicity, integrity,.....)
Automatically, the system give a yellow screen containing for example (here, in access, a problem of integrity)

Error # = 80040E14(-2147217900)
Description = [Microsoft][ODBC Microsoft Access 97 Driver] You can't add or change a record because a related record is required in table 'tUser'.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = 23000
Native Error = -1613

Is it possible to intercept this kind of error ?
I tried with session("SV_ERROR_ID&#34, but this variable is updated after the problem occurs.
I don't want to use a combo box (very not easy when we have more than 12,000 records in the related table). In fact, the users knows the code by heart, but they are humans, so, sometimes, they did some mistakes.

Thank you for any idea.

Michel