Microsoft Access 2010 Bible

Chapter 2: Creating Access Tables

75

FIGURE 2.23

The Lookup tab for a Yes/No field

FIGURE 2.24

Setting up a combo box as the display control for Credit Status

Combo box is selected

Values displayed for this field

Although Figure 2.24 shows a combo box using a value list for its items, you could also specify a

query or SQL statement as the combo box’s row source.

Figure 2.25 shows how the Credit Status field appears when tblCustomers is displayed as

a datasheet. The user can select only OK or Not OK as the credit status, and the same combo box

appears when the field is added to an Access form.

The properties for a Lookup field are different for each data type. The Yes/No data type fields

differ from Text fields or Number fields. Because a Lookup field is really a combo box, the stan-

dard properties for a combo box are displayed when you select a Lookup field data type.