Untrappable error

  • Thread starter Thread starter Ed Jobe
  • Start date Start date
E

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?
 
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.
 
Back
Top