yes, the blank record is created and saved.

I have checked lastkey() in the Help but cannot find any clue.

I decided to add a flag, so the code becomes

thisflag=vinvdetail.flag
select stock_id from vinvdetail into curs temp where stock_id=this.value and thisflag<>vinvdetail.flag
if _tally<>0	
   wait windows 'This item already exist...' timeout 1
endif

seems not very efficiens but it works.

thanks for the help