Buttons on Query Forms

Query forms have the following 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 pane. This value can be returned to the corresponding field in the parent form. NOTES: 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. You should be aware, though, that if you do this, the system will overwrite the previous collection on the multiview form 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, as 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.

Button

Description

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 pane. This value can be returned to the corresponding field in the parent form.

NOTES:

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. You should be aware, though, that if you do this, the system will overwrite the previous collection on the multiview form 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, as 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.

Buttons on Query Forms

Related Topics