Open topic with navigation

Creating a Query Prompt

A query prompt allows users to enter criterion for a database query at print-time. It can be used as a separate user-input dialog or can be associated with a control on a data entry form.

ClosedTo create a query prompt

  1. From the File menu, select Database Connection Setup to open the Database Setup dialog. Alternatively, click the icon on the main toolbar. If you have not previously connected to a database, this will launch the Database Setup Wizard. Complete the wizard to display the Database Setup dialog.

  2. From the Navigation Pane of the Database Setup dialog, select Filter to open the Filter property page.

  3. Click on And and select the desired joiner for the filter. For a list of available joiners, refer to Conditional Printing.

  4. Click to create a new filter.

  5. Click on the Database Field and select the field that will determine which records will print.

  6. Click on the Operator and select the desired operator for use.

  7. Click <enter a value> and select New Query Prompt to open the Query Prompts dialog, where you can name your query prompt and configure its properties.

  8. Click OK to close the Query Prompts dialog.

  9. Click Apply Filter and enter into the resulting dialog your criterion. This will apply your filter and display the results.

  10. Click OK to close the Database Setup dialog.

Specifying the query prompt's properties in the Query Prompts dialog is only necessary if you do not plan to associate the query prompt with a data entry control on the data entry form. Otherwise, when you associate the query prompt with a data entry control, the options are set using the control's property pages.

Related Topics