Open a report.

      DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition,
                       WindowMode, OpenArgs)

   ReportName     The name of the report to open.

   View           An AcView constant that specifies the view
                  in which the report will open. Default=acViewNormal

   FilterName     The name of a query saved in the current database.

   WhereCondition An SQL WHERE clause (without the word WHERE.)

   WindowMode     An AcWindowMode constant that specifies the
                  window mode in which the report opens.
                  default = acWindowNormal.

   OpenArgs       A string expression that is used to set the report’s
                  OpenArgs property. This can then be used by code
                  in a report module.

Use OpenReport to open a report in Design view or Print Preview, or to print the report immediately.


'Open rptTravel
DoCmd.OpenReport "rptTravel", acViewNormal

“I get all the news I need from the weather report” ~ Paul Simon


OpenForm - Open a form.
SetParameter - Set a parameter before opening a Form or Report.

Copyright © 1999-2023
Some rights reserved