Combo Fields

The Combo field is used to provide the user with a specific set of options that can be selected from a drop down box.

Combo Field in Palette

Define the Combo Field

Drag and drop the Combo field from the Palette window onto the Fields Pane.  The Field Properties window will open, which provides the means for configuring the field.  Enter the field information such as field name, display name, etc., by clicking in the field and typing the information.  

Determine the Contents of the Combo Box

The Query and Calculated properties can be used to populate the combo box.  Click the button to the right of the Query property to open the Combo Field Query window.  Select the Query type and then enter the statement in the box provided. The Test button can be used to make sure the statement runs without errors.  Click OK when the query is complete.  

Click the button to the right of the Calculated property to open the Combo Field Calculated window.  Select the type of calculation, the method and then enter any necessary statements in the box provided.  The Test button is an additional tool that can be used to run through the statement to see if any errors occur.  Select OK when the calculated information is complete.

Query Property and Combo Field Query Window