Microsoft Access 2010 Bible

Part IV: Professional Database Development

882

Figure 25.1 shows frmProducts with an additional control at the top — a combo box that is not

bound to any data in the form. The unbound combo box is used to directly look up a record in

tblProducts and then display the record in the form using a bit of code. This chapter shows

several ways to build this combo box and use it as a quick way to find records in the form.

FIGURE 25.1

The frmProductsExample1 form with an unbound combo box

The design for the combo box is shown in Figure 25.2. Notice that the Control Source prop-

erty is empty. This indicates that the combo box is not bound to any field in a table and is used

only by the form, not to change data in the underlying database.

FIGURE 25.2

The Property Sheet for the unbound combo box control