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
James Beerbower
James Beerbower Enterprises
Frankfurt, Deutschland