Hi Jim,
This is normal behavior when you return .f. in the valid event. What is it you'd like to happen when an invalid entry is made?
It may be a glitch in grids that causes different behavior there.
>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?
kenweber
GCom2 Solutions
Microsoft Certified Professional