>>>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?
Edward Pikman
Independent Consultant