Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Creating Smarter Forms
Figure 3-3:
Choose
which field
will appear
when the
user clicks
the combo
box and
the
dropdown menu
appears.
8. Adjust the widths of the columns by dragging the column divider left
or right, click Next, and skip to Step 10 unless you’re typing values
instead of using a table.
Depending on the fields you’ve chosen, Access may display a check box
titled Hide Key Column (Recommended). If this box is checked, the key
column that you selected won’t be displayed.
9. If you chose to type the list of values, type them in the datasheet, one
per row, and then click Next.
The wizard displays a datasheet in which you can type the list. You can
create multiple columns (for a code and its meaning, for example), one
of which will be stored in the record source of the form.
10. Choose the field that identifies each row of the combo box, and
click Next.
The wizard asks which field uniquely identifies each row in the combo
box — the equivalent of the primary key field in a stored table. (Aren’t
you beginning to wish that you’d just stored the list in the table? Hint,
hint!) This value is what gets saved as the value of the combo box in the
next step.
Book IV
Chapter 3
11. Choose whether to remember the value for later use or store it in a
field, and click Next.
The wizard asks what you want to do with the value of the field when the
user chooses it from the combo box: remember the value for later use
(refer to it in a query parameter, macro, or Visual Basic for Applications
[VBA] module), or store it in a field of the table or query that’s the
record source for the form. Most of the time, you want to store the value
in a field, so choose the field name from the list.
12. Type a label for the combo box, and click Finish.
The wizard creates your combo box.
Search JabSto ::




Custom Search