Trapping error 3022 in order to automatically navigate to the pre-existing record

[hunterw]

Howdy all,



I've hit a snag. I have a surrogate primary key - a unique ID that is input by the user. Frequently people will enter an ID in order to fill out a different part of my form, and they will have no idea if the record exists yet or not.



I need to trap error 3022 and automatically navigate to the pre-existing record. How can I go about doing this?



Thanks in advance!

 

[BamaBraves]

You could use a DLookup in the AfterUpdate event of the ID field to see if the ID entered is all ready used before the rest of the form is filled.

I assume you are getting the error when attempting to update the table.