Trap dup key on rs.update, change key and re-try update ?

[somanybugssolittletimetofixthem]

I have some code that creates a key based on user first and last name and location. In the unlikely event this leads to a dup key my rs.update fails. Is it possible to trap this with 'on error' so I can change the key and retry the rs.update ?
Example code would be much appreciated.

Thanks for any help.

 

[Al Borges]

Hi somany:

Go to the thread "Delete a Record from a Table" which began on 6/8/2004...
in my note I handle error trapping in such situations. Let me know if you
can't find it.

Regards,
Al

I have some code that creates a key based on user first and last name and

location. In the unlikely event this leads to a dup key my rs.update fails.
Is it possible to trap this with 'on error' so I can change the key and
retry the rs.update ?