>>I have a form that has a txt box on it. When the operator types a number not in the table, I want the focus to return back to the box so they can re-type another one.
>>I have the select on entry to T so that the whole value is highlighted when the object has focus.
>>
>>I am getting an error with this.
>>
>>Any suggestions?
>>
>>Thanks in advance.
>
>You may evaluate This.Value in Control.LostFocus event and if it's not good fire
>NODEFAULT
>This.Setfocus

Ed,

I tried to leave the code the way it was in the valid event and received an error that I cannot have an error that I cannot call a setfocus from within a when statement.

SELECT saw_data_table
SET order to column1
IF ! seek(UPPER(alltrim(this.value)))
MESSAGEBOX("That part is not on Record")
nodefault
this.setfocus
ELSE
thisform.refresh()
ENDIf


this is what I have. If I use the lostfocus event, won't I still have the error. If so, what is the best way to work around this.

Many thanks,
Brad.