Hi, how are you?

I was wondering if it is possible to catch an error code from an MS Access database and use this code in a customised error message.

For example, if a user is trying to duplicate records to a database, MS Access will return an error code. Is it possible to catch this error code and put this into an error page or call a custom made error page.

All help greatfully recieved!

Morris

You could write a function that checks if the record exists then give your own custom error.