>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.