Microsoft Office 2003 All-in-One

So far, you've taken a look at adding controls to a form that directly relate to fields that exist in an associated table or tables. This means that unless the control is linked to a table's field that uses the AutoNumber data type, you are going to have to type all the data that you enter into the form (exactly as you would in the table).

Fortunately, Access offers some special form controls that can be used to help you enter data. For example, a list box contains a list of entries for a control from which you must choose when entering data. All you have to do is select the appropriate entry from the list. Other special controls also exist that can make it easier to get your data into the form. These controls are:

• List Box Presents a list from which you choose an item.

• Combo Group Like a list box, but you can type in other entries in addition to those on the list.

• Option Group Provides you with different types of input buttons (you can select only one type of button when you create an Option group). You can use option buttons, toggle buttons , or check boxes.

• Command Button Performs some function when you click it, such as starting another program, printing a report, saving the record, or anything else you specify.

Figure 12.1 shows some special controls in the Form view. In this lesson, you create each of these control types.

All these special controls can be created using the buttons on the Toolbox. Wizards are also available that walk you through the steps of creating each of these special control types. To use the wizard for a particular special control, make sure that the Control Wizards button is activated on the Toolbox. Figure 12.2 shows the Toolbox and the buttons that you are working with in this lesson.