Untrappable error

[Ed Jobe]

I'm trying to trap error 3022, which occurs when I add a record with an
indexed key that already exists, creating a duplicate where duplicates
aren't allowed. The error seems to occur after the BeforeUpdate event and
before the AfterUpdate event. Any ideas on how to trap this error?

 

[Van T. Dinh]

Try the Form_Error Event.

Check Access VB Help on the above Event.

 

[Ed Jobe]

Thanks. I hadn't used that event before. But I need to trap the error in the
BeforeUpdate event so that I can avoid performing some steps I have coded
there. Therefore I'm checking the recordset at that point for duplicate
records.

Thanks again.