Hey Larry,

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

Take a look at PRIMARY and CANDIDATE indexes.