Access 2016 Advanced

Lesson 11 – Using Macros

Access 2016

Adding a condition to a macro using the If block



Procedures

1. Open the desired database. 2. Open the desired macro in the Macro Tools Design contextual tab.

3. Double-click If in the Action Catalog pane. 4. Type the condition expression in the IF field. 5. Type (or copy) the Then action in the Then then field.



Step-by-Step

Add a condition to a macro.

Open the Limit macro in Design view.

Steps

Practice Data

1. Double-click the If button in the Action Catalog pane. Opens the If argument block. 2. Type the condition expression in the field. The condition appears in the field .

Double-click If

Type Forms![Customers1]![Credit Limit]<3000

Page 130

OFFICEPRO, Inc.