Microsoft Office Tutorials and References
In Depth Information
Creating combo boxes
Create a combo box based on a table
6 Choose the required fields to use. (In our example, we have a
numerical ID field, which is the value to be saved, and a text
description field, which is the value to be shown.) Click Next. On the
next screen choose a field to sort the choices, and click Next.
7 Accept the default to hide the key column, and click Next.
8 Click Store That Value In This Field.
9 Select the database field from the drop-down list, and click Next.
On the next screen provide a caption for the control, and click
TIP A combo box can display a drop-down list of multiple
columns but can display only one of the columns as selected. If
you need to show data from more than one column, you can use a
query to create a calculated column combining the values from several