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.
Set the Before Update property for the Title text box to AreYouSure.
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.
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.
For more information about the MsgBox function, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type msgbox function in the Office Assistant or the Answer Wizard, and then click Search to view the topic.