image\COMBOBOXBUTTON.gif Use a ComboBox component to combine an entry field and a drop-down list box. A user clicks the down-arrow button to display the list. A ComboBox accepts a value typed into the entry field or selected from the drop-down list box. In a running form, the value a user selects or types into a ComboBox is added to the appropriate linked table.

You can use ComboBox controls for string, numeric, date, and Boolean fields.

To link a ComboBox component to a table field,

You must have a Query object on the form or report that contains the field you need.

Click the wrench tool beside the ComboBox's dataLink property, and use the Choose Field dialog box to choose the field you want to link to.

To display choices in the ComboBox,

  1. Click the wrench tool beside the ComboBox's dataSource property.

If you will need to often change the selection options listed in the drop-down list, it may be more convenient to keep the items in a separate table rather than an array built into the application. In this way, when you want to change the items in the drop-down menu you just need to update the linked table. To implement this approach requires writing a few lines of code in the Source editor.