Microsoft Access 2010 Bible

Chapter 30: Using Access Macros

1063

Submacro Name Condition Action

Action

Argument

Action

Argument

Setting

[Forms]![frmReportMenu

]![fraView]=2

OpenReport Report Name rptProducts

View Print

Preview

Window Mode Normal

OpenSales [Forms]![frmReportMenu

]![fraView]=1

OpenReport Report Name rptSales

View Print

Preview

Window Mode Normal

[Forms]![frmReportMenu

]![fraView]=2

OpenReport Report Name rptSales

View Print

Preview

Window Mode Normal

FIGURE 30.10

mcrReportMenu uses an If action to open reports in Print or Print Preview view.

If macro action