• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Working with Reports > Populating the Report

Populating the Report

The existing billing report shows one way of limiting the records that populate the report. The report’s query grabs values from the setup form. It’s a simple technique and requires no VBA code other than the short procedure needed to launch the report from the form.

VBA has an alternative to this technique. As mentioned earlier, you can use a couple of the OpenReport method’s arguments to specify a particular query or even a WHERE clause. If you choose this route, you need to remove the form references from the report’s underlying query and then replace the report opening command button’s Click event with the following procedure:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint