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().