ADODB Record Upate

Hello,

I am using ADODB to create new record in an access db. Now, that I'm past that hurdle, how do I check if the unique key already exists and then update that record? Any help would be greatly appreciated.

Please Login or Register  to view this content.

Mike,

Thank you. Exactly what I was trying to do.

Mike,

I finally have played with the code a little. I get a Run-time error 3219. If I add .Update before the 'end if' it throws a Run-time error -214217887 (80040e21) - "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again." Where am I going wrong? Here is my code below:

Please Login or Register  to view this content.

Mike,

I made a mistake. I've tried your method in your last reply. If I add .Update before the 'end if' it throws a Run-time error -214217887 (80040e21) - "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index or redefine the index to permit duplicate entries and try again."

Mike,

I've had some time to play with the code. For some reason the EOF if statement is skipped even if the record exists. Any ideas?