This function may return one of three values:

• 0 There is no loaded record containing the specified field.
• 1 There is a loaded record containing the specified field.
• 2 There is a loaded record containing the specified field, but the record is locked. This means that the field may be read, but not written to.

The following method, attached to the Before Group event, finds the first customer with an order. If no customer has an order, or an error occurs, then the first customer in the table is selected.

While IsField(OrderNo) = 0

NextRecord

if syserror then

FirstRecord
Exit While

end if

end while