>>I want to check for duplicates before I commit a new record.
>>
>>My form uses bound text boxes and the 'Add' button appends a blank record. When the text boxes are filled in, and I search for a pre-existing record using the key fields, I find the record I'm adding!!!
>>
>>What is the right way to do this? Does it involve public/private datasessions - buffermode settings - etc.?
>>
>>Please be specific, this is driving me crazy...
>>
>>TIA
>
>Usually, INSERT-SQL is preferable to create new records, i.e. you generate unique key first and then use it to get a record.

Well, For using a Cursor to hold the table data, and would work like:

If the Primary Key, Replace the existing record, as some field(s) may change!
else insert a new record of the data.