Microsoft Office Tutorials and References
In Depth Information
Creating combo boxes
Creating combo boxes
As an alternative to the preceding example, where the control
displayed a set of fixed values, the values in a combo or list box
can be taken from either a table or query.
you needed to change the values, you would have to make the
change on all forms that used the control containing the fixed
values. However, with data from a table or query, the current
available choices are always displayed.
Using a table or query has an advantage over creating a control
by using an explicit set of values because, in the latter case, if
2
1
Create a combo box based on a table
1 On the Form Design Tools ribbon, click the Design tab with a form
open in design view.
2 Click the combo box button in the Controls toolbox.
3 Click to position the control on the form.
4 Select the default option to get values from a table or query, and
then click Next.
5 Select the table containing the data, and then click Next.
(continued on next page)
3
4
TIP As a result of your choices in the Combo Box Wizard,
several key properties are set on the combo box control that
you can subsequently change. For example, in the Format properties,
Column Count is the number of columns, Column Widths is the width of
each column (0 is for a hidden column), and List Rows is the number of
rows in the drop-down box. The Column Heads property controls
whether column headers are shown, and in the Data properties, Limit
To List restricts entries to values in the list.
5
Search JabSto ::




Custom Search