Microsoft Access 2010 Bible

(Rick Simeone) #1

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.
Free download pdf