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

H

hunterw

Joined
Jun 12, 2008
Messages
9
Reaction score
0
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 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MS Access VBA - 3022 error 3
Getting error 3022 trying to add record 6
DMax on existing record to increment serialized # fails 1
Navigate from the subform record to view the complete order 1
Forcing record creation order? Violation of Check Constraint. 1
error trapping 3
How to Find Record if Exists, Add if not? 7
Error 3201 You can't add or change a record...when delete/deleting 2

Top