Find dialog box

Use this dialog box to find a record that contains a specified value in a field.

If there is a match, the system displays the first record that contains a matching value. To find the next matching record, select Edit > Repeat Find.

The sort order of the collection determines the order in which you find matching records. For more information about sort order, see Sorting Collections.

Note that this search applies only to a collection that has already been retrieved and does not query the database again. If you need to search all records, you can, if necessary change the cap on records retrieved. For more information, see Caps on Collections.

The following table lists the elements of this dialog box and explains their use.

Element Function/Comments
Find Specify the value you want to find, such as a word or number.

The Find feature uses what is known as an "implied wildcard" search.

See Using wildcards.

In Collection Select the name of the collection you want to search.

If you do not know the name, return to the form and select Help > About This Form to see the name of the current collection.

In Property Select the name of the field you want to search.
Case Sensitive To find records that have the exact capitalization you typed, select this check box.

To display this dialog box, place the cursor in the field for which you want to locate a value and select Edit > Find Value in Collection.