ADODB Record Upate

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?