I simply want to check if an id number entered in a TextBox exists in the table. The id is attached to the physical document but should not be duplicated, therefore I would like to check it against the existing table. The Valid Event seem like the logical choice. I have the following code in the Valid Event:

lcID = alltrim(this.value)

locate for alltrim(drawing.id_no) = lcID
if found()
=MessageBox(lcID)+' already exists!')
return .f.
else
return .t.
endif

For some reason that's beyond me (at least at the moment) it won't tab off if the id doesn't exist in the table, in fact it's pretty difficult to get it out of the TextBox once entered. The same basic process works in a grid on the same form. What am I missing?