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.
Made with FlippingBook - Online magazine maker