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:

  • It loads the records as a collection into a parent form, or
  • It returns a single value in a specified field to the corresponding field in a record in a parent form.

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.

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.

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.