>>>>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.
>
>You may use LostFocus event (no errors there). Why don't you like it?


Hey Ed thanks a 100k it works well.

have a great weekend!!!!

Brad.