F. Scott Barker's Microsoft® Access 2000 Power Programming

CHOOSING MULTIPLE TOPICS TO PRINT BY USING THE MULTISELECT LIST BOX

Using the ListBox control in MultiSelect view is extremely useful for generating reports and giving users more control over what information is printed.

In the example created here, users get the option of selecting one, some, or all categories of products for which to print a report (see Figure 11.23). It uses the list box quite extensively, including adding and removing categories to a temporary table for the report. This is a nice way of using the list box and an additional text box because users see exactly what has to be selected.

Figure 11.23. Using the MultiSelect version of the list box can make a powerful report.

Looking at the MultiSelectCategoryExample Report

The ...