Buttons on Query Forms

Query forms have these action buttons:

Button Description
OK Click to return any search results that match the current criteria to the parent multiview form and close the query form.

If you opened the query form to perform a form-level query, the result set is a collection of records, which can be returned to the parent form. If you opened the query form to find a value for a single field in a form, the result is a field value in the currently selected record in the results grid. This value can be returned to the corresponding field in the parent form.

Be aware of this information:

  • When you click this button, if you have selected any results to return to the parent form, the system prompts you for confirmation. If you want to return the results to the parent form, click Yes. If you do this, the previous collection on the multiview form is overwritten with the collection being returned from the query form.
  • In a form-level query, records returned to the parent form match the current criteria. These records may be different from records displayed in the Results pane. The difference can occur when you specify criteria, click Refresh to display the search results, and then change the criteria without clicking Refresh to display the new results.
  • This is typically the last button you click on the query form, because it returns you to the parent multiview form. To get the results of your query, you must first click Refresh.
Cancel Closes the query form without returning any search results to the parent multiview form.

Whether you opened the query form from a form or a field, no information is returned to the parent form or field.

Clear Clears any search criteria from the query form without closing it.

This can be useful if you make a mistake and want to start over without having to close the query form.

Refresh Searches the database using the current criteria and displays the selected records in the results grid.
Add (Additional Criteria tab only) Adds the criteria currently in the specification fields to the list of query clauses.

Criteria in the specification fields do not become part of the filter until you click this button.

Remove (Additional Criteria tab only) Removes the selected query clause from the list of clauses.