Special Edition Using Access 97, Second Edition

Drilling Down from a List Box Selection

The most common use of a drill-down form that displays a list of orders is to present the line items of a particular order. It's relatively easy to add and program a line items list box, based on the Order Details table, to the form you created in the preceding sections. An additional use of the line items list box is to verify that the cboProduct combo box correctly performs its assigned role.

Creating the Drill-Down Query and Adding the List Box

Create the query and add the list box with the following steps:

1.	Create a new query and add the Order Details and Products tables.
2.	Drag the Product Name field of the Products table and the OrderID, UnitPrice, Quantity, and Discount fields of the Order ...