Find with validation fields

[fish]

Here is my situation: I have a script that goes to a layout and enters find mode. I have set error capture on, and any result that is not "0" should cause a return to the original layout with a general error message. However, one of the fields is from a related database and is a numeric field and is set to not allow an empty field. If I try to use a "*" to search fory any entry, I just get an error that data needs to be entered here (this does not happen if it is left blank in find mode, which is ok). My script cannot continue to the original layout because invalid data is entered here. I would like to be able to return to the original layout in the case of ANY error. Thanks for any help.

[CyborgSam]

* doesn't work in number fields, use = (empty) and Show Omitted. Here's the bare script steps:

Enter Find Mode

Insert Text [select, "myNumberField", "="]

Perform Find [Replace Found Set]

Show Omitted

[CyborgSam]

Forgot this, put after Show Omitted:

If ["Status(CurrentFoundCount) <> 0"]

... do your thing to point out error

Else

... do whatever comes next if all OK

End If