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