I would suggest

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

return 0 leaves the focus in the current text box with out calling VFPs error message.

James Beerbower