O'Reilly logo

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

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

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

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