Nancy, no any problems. I just was concerned that initial poster will get things wrong way :-).
>Ed-
>
>I was commenting on an alternative approach of using an unbound control and searching for the value. I believe that is clear if you reread my post. If not, I apologize for any confusion.
>
>>It has nothing to do with using or not using buffering. It's about primary/candidate keys and proper error trapping applied on INSERT/REPLACE or, in case of buffering, TABLEUPDATE().
Edward Pikman
Independent Consultant