>Hi Michelle,
>
>>When the user is entering a new record, how do you check to be sure a field doesn't have a duplicate value without moving the record pointer? This also would have to take into account buffering.
>
>I create a method or procedure or ect. that opens the table in a new work area, searches the passed field for the passed value, then checks to see if the result is the PK passed from the old WA. This should work regarless of buffering, ect. If you need code I could probably post it, but you shuld be able to get the idea.

That's a good idea.

Thanks,

Michelle