Microsoft KB Archive/209549

= ACC2000: How to Use a Conditional Macro to Confirm Changes to a Field =

Article ID: 209549

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209549



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SUMMARY
This article shows you how to use a conditional macro to prompt the user to confirm changes to a field.



MORE INFORMATION
To use a conditional macro to prompt the user to confirm changes to a field in a form, follow these steps:

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

 Start Microsoft Access, and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp.  In the Database window, click Macros, and then click New. On the View menu, click Conditions to display the Condition column. Create the following new macro:   Condition                      Action         Action Arguments ---  MsgBox("Commit changes?",1)=2  CancelEvent ...                           SendKeys       Keystrokes: {ESC} Wait: NO NOTE: The ellipsis in the Condition column forces Microsoft Access to perform the action on that line if the condition on the preceding line is true. Access evaluates macro conditions as true or false. If the expression is true, Access performs the action; if it is false, Access ignores the action.

 Save the macro as AreYouSure. In the Database window, click Forms, click Employees, and then click Design to open the Employees form in Design view. On the View menu, click Properties to open the property sheet, if it is not already open. Click the Title text box to select it.</li> Set the Before Update property for the Title text box to AreYouSure .</li> On the View menu, click Form View. Change the information in the Title field. Press the TAB key to move to the next field. When a confirmation message appears, click OK to confirm your change, or click Cancel to cancel your change.</li></ol>

NOTE: This example uses the MsgBox function instead of the MsgBox action. The MsgBox action has only an OK button, whereas the MsgBox function can also include a Cancel button.

<div class="references_section">