You cannot add or change a record

[hbrems]

You cannot add or change a record because a record is required in <table>.

Simple question (simple answer too I hope). How can I trap this referential integrity error?

I would like to create a more user friendly message.

 

[rainman89]

try trapping error 3201

i believe that is the code for that error

 

[hbrems]

try trapping error 3201

i believe that is the code for that error

Either that's not the correct err.number or I'm doing something wrong...

At what stage do you suggest I trap this error? I tried:

- form unload
- form close

In both case the error message still pooped up. My aim is to trap when somebody tries to exit the form by:

- clicking a custom close button
- clicking 'x' on the form
- clicking 'x' in top right corner (which closes Access completely)
- choosing file > exit

Kind regards,
Hans B.

 

[hbrems]

Anyone?

 

[hbrems]

Ok,

so I found out how to trap the messages. I use the on error event:

Instead of

select case err.number

I needed

select case DataErr

This allows me to display my custom message. The only thing I need now is to know how to suppress the original message.

Kind regards,
Hans B.

 

[hbrems]

Nevermind:

Response = acDataErrContinue