On Error GoTo MyErrorRoutine except when error number is 3022
I have a routine that does a fair amount of work on a table. I need a general error trap in case it encounters an unexpected error, however in just one small section of code I need to have it ignore a .Update command if the error code is 3022 (duplicate key) and just abandon the .Update. Can anyone tell me how to do it?
!Value = "My Value"
!Value2 = "My Other Value"
.Update 'only in this step of the code, abandon the update if the record has already been added