Query Form

Use this query form to specify selection criteria and to retrieve records from the database. The form performs one of two actions with retrieved records:

The type of action depends on how you opened the query form.

If you opened it from another form by selecting Actions > Filter>By Query (or an equivalent method), then the query form returns all records that match your selection criteria to the first form. In this situation, the title of the query form includes "(Retrieving Filter)" to indicate its functional mode. See Finding Records with a Query Form.

If you opened the query form from another form by clicking in a drop-down list field and then selecting Edit>Find Value for Current Field (or an equivalent method), then the form returns the value of a field in the currently selected record in the Results pane to the corresponding field in the first form. In this situation, the title of the query form includes "(Find)" to indicate its functional mode. See Finding a Value for a Drop-Down List Field.

If you did not open the form from another form but from the Explorer window or by selecting Form>Open, any records retrieved from the database are simply cleared when you close the form.


Related Topics

Additional Criteria in Query Forms

Buttons on Query Forms

Finding Records Using a Query Form

Operators on Query Forms

Primary Criteria in Query Forms

Sample Queries

Understanding Filters

Using Wildcard Characters

Using the Null Keyword