O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required