Try this:


LOCATE for fullpric.catno = Thisform.txtFind.Value

IF FOUND()

do something
ELSE
do form FindCatNo
ENDIF

If the user entry is not there, pop up a picklist, let them select a number and return to your original form.