Free E-Books

Figure 27-11 shows frmFilterProducts, which contains a combo box for selecting a record. On the
left side of Figure 27-11 the combo box is closed while the right side shows the combo box open.
FIGURE 27-11
Creating a dialog box for selecting records
A combo box gives the user the choice of selecting a single record from a set of records or entering
a wildcard (if the combo box??™s Limit to List property is False). The combo box (cboDescription)
shown in Figure 27-11 contains two columns??”Description and Seller. The Description is the
bound column and makes the selected description available to a query that references the combo
box, as shown in Figure 27-12.
Figure 27-12 shows qryProductFormReference. This query selects all the fields in tblProducts
based on the description retrieved from the combo box on frmFilterProducts. Notice the expression
in the query criteria area:
Like [Forms]![frmFilterProducts]![cboDescription] & ???*???
This expression references cboDescription in frmFilterProducts.


Pages:
1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660