This page explains the uses for other types of form controls including
lists, combo boxes, checkboxes, option groups, and command buttons.
List and Combo Boxes
If there are small, finite number of values for a certain field
on a form, using combo or list boxes may be a quicker and easier
way of entering data. These two control types differ in the number
of values they display. List values are all displayed while the
combo box values are not displayed until the arrow button is clicked
to open it as shown in these examples:
By using a combo or list box, the name of the academic building
does not need to be typed for every record. Instead, it simply needs
to be selected from the list. Follow these steps to add a list or
combo box to a form:
Open the form in Design View.
Select View|Toolbox to view the toolbox and make sure
the "Control Wizards" button is pressed in.
Click the list or combo box tool button and draw the outline
on the form. The combo box wizard dialog box will appear.
Select the source type for the list or combo box values and
click Next >.
Depending on your choice in the first dialog box, the next options
will vary. If you chose to look up values from a table or query,
the following box will be displayed. Select the table or query
from which the values of the combo box will come from. Click Next
> and choose fields from the table or query that was selected.
Click Next > to proceed.
On the next dialog box, set the width of the combo box by clicking
and dragging the right edge of the column. Click Next >.
The next dialog box allows tells Access what to do with the
value that is selected. Choose "Remember the value for later
use" to use the value in a macro or procedure (the value
is discarded when the form is closed), or select the field that
the value should be stored in. Click Next > to proceed
to the final screen.
Type the name that will appear on the box's label and click
Check Boxes and Option Buttons
Use check boxes and option buttons to display yes/no, true/false,
or on/off values. Only one value from a group of option buttons
can be selected while any or all values from a check box group can
be chosen. Typically, these controls should be used when five or
less options are available. Combo boxes or lists should be used
for long lists of options. To add a checkbox or option group:
Click the Option Group tool on the toolbox and draw the
area where the group will be placed on the form with the mouse.
The option group wizard dialog box will appear.
On the first window, enter labels for the options and click
the tab key to enter additional labels. Click Next >
when finished typing labels.
On the next window, select a default value if there is any and
click Next >.
Select values for the options and click Next >.
Choose what should be done with the value and click Next
Choose the type and style of the option group and click Next
Type the caption for the option group and click Finish.
In this example, a command button beside each record is used to
open another form.
Open the form in Design View and ensure that the Control Wizard
button on the toolbox is pressed in.
Click the command button icon on the toolbox and draw the button
on the form. The Command Button Wizard will then appear.
On the first dialog window, action categories are displayed
in the left list while the right list displays the actions in
each category. Select an action for the command button and click
The next few pages of options will vary based on the action
you selected. Continue selecting options for the command button.
Choose the appearance of the button by entering caption text
or selecting a picture. Check the Show All Pictures box
to view the full list of available images. Click Next >.
Enter a name for the command button and click Finish
to create the button.