USING QUERY BY FORM TO CREATE DYNAMIC GROUPINGS FOR THE SAME REPORT

You can actually make dynamic groupings without using code on the report. The report used for this example is named DynamicGroupingsExample. Also used is a form with the same name.

Before you look at the report itself, notice that the form used with the report is similar to the last example. This form contains an option group (optGroupBy) and two command buttons (cmdPreview and cmdClose). Figure 11.7 shows the DynamicGroupingsExample form in Run view.

Figure 11.7. By accessing the optGroupBy option group, you can group the report in different ways.

As with the last example, the ...

Get F. Scott Barker's Microsoft® Access 2000 Power Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.