Specifications

Modifying general form properties
558 InfoMaker
Prompting for retrieval criteria in a form
You can define your form so that it always prompts you for retrieval criteria
just before it retrieves data. In this way, you limit the data retrieved.
❖ To prompt for retrieval criteria in a form:
1 Select Design>Prompt for Criteria from the menu bar.
The Prompt for Criteria dialog box displays, listing all columns in the
form:
2 Select the columns for which you want to specify retrieval criteria when
you run the form.
3 Click OK.
What happens
If you have specified prompting for criteria, InfoMaker displays the Specify
Retrieval Criteria dialog box when you run the form—just before the retrieval
is done.
Each column you selected in the Prompt for Criteria dialog box displays in the
grid. For example, if you selected the State column and the Salary column, you
can specify criteria so that only data for employees in Massachusetts with
salaries greater than $50,000 is retrieved:
You specify criteria exactly as you do in the grid with the Quick Select data
source. Criteria specified are added to the
WHERE clause for the SQL SELECT
statement defined for the form.