Querying for Records in a Selection Dialog Box

You can query in a selection dialog box just as you query in a list or form. Consequently, you can search for specific information from one field or from several fields simultaneously.

To query for records in a selection dialog box

  1. In the selection dialog box, click Query (the magnifying glass icon).

    A blank row appears in the selection dialog box.

  2. Enter your query criteria in the appropriate fields.

    A wildcard is automatically assumed after text you enter in the query fields. If you search for Siebe, then all words beginning with the letters Siebe are found.

    If you query a data field that has a calendar select button to display the calendar control, then you must include the date field value in quotes if you execute the query without specifying a time. For more information about entering query criteria, see Simple Query Operators.

  3. Click Go.

    The records matching your query criteria appear.