I'm raising the error with requery like this:ĭoCmd.Save acForm, Me.Name 'next line triggers 3022Īfter I realised that the normal handler wouldn't trap it I got the database from this thread: So on the offchance that two clients are trying to autogenerate a key at exactly the same time, I'm trying to trap the 3022 error raised when a duplicate key is entered so that I can repeat the operation with a goto. My table has an auto generated key as a string.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |