Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Creating Smarter Forms
4. Drag the cursor down and to the right to outline the border of the
combo box, and release the mouse button when the outline is the size
Access displays the Combo Box Wizard, shown in Figure 3-2.
5. Specify where the list of values comes from, and click Next.
If the list comes from an existing table or query, choose the first option,
and go to Step 6. If the list of options doesn’t exist in a table, choose the
second option, and go to Step 9. The third option creates a combo box
that lets you jump to a specific record in your table (see “Making a Find
Box,” later in this chapter).
The wizard displays all the tables, all the queries, or both so that you
can choose the table or query you want. If the table doesn’t have a
primary key field, you can’t choose it.
6. When the wizard shows you a list of the fields in the table or query,
choose the fields to display in the combo box and then click Next.
You can choose more than one field if you want more than one to
appear in the combo box. Double-click a field in the Available Fields list
to move it to the Selected Fields list (and vice versa). In Figure 3-3, two
fields are selected.
7. Choose the field you want to display and the order in which you want
the records to appear in the combo box, and then click Next.
The wizard allows you to choose Ascending or Descending order for up
to four fields.
Be sure that the field on which you’re sorting also appears in the combo
box; otherwise, the order can be confusing. If you sort states and
provinces by their two-letter codes, for example, the names don’t appear in
order, which looks weird if the codes don’t also appear.