>Hi Jim, John, and Erik
>
>What about on an Edit as opposed to an Add? I know using Jim's method if I type in the same value I had, I will find my own record and fail. Will the other methods work?

WHen I have to do this, I usually use another alias, and locate for UNiqueval = this.value and SomeOtherValThatIKNowWillBeDifferent <> Table.ThatVal.