Microsoft Office 2000/Visual Basic Programmer's Guide

Using Subforms to Create Filterable Reports in an Access Database

Access reports and report snapshots can be filtered and sorted only when they are being created. If you want the user to be able to filter on one or two specific fields, you can use a subform within an Access form to make a tabular report. You can also use a combo box to present the filter criteria to the user, and filter the data in the subform according to the user’s choice in the combo box.

For an example of a form that uses a subform to create a filterable report, see the frmProductsByCategory form in the NorthwindReports.mdb sample file, which is available in the ODETools\V9\Samples\OPG\Samples\CH15 subfolder on the Office 2000 Developer CD-ROM.