How to run a macro on AfterOpen Event 1

[CK8]

How can I run a Warning Message AfterOpen on a form where I want it to first look at a check box. If the Check box is checked I want the message macro to run; if no check in the box then no Message. Message is "Please Confirm Address"

I already have the macro for the message created, but I can't make it look at the check box (named: ConAddressAlert)on the form and then run if the box is checked.

Help Thanks

CK8

 

[jebry]

Hi CK8!

In the Form_Current Event Procedure, put the following code:

If YourCheckBox.Value = True Then
DoCmd.RunMacro "YourMacroName"
End If

Alternatively you can use:

If YourCheckBox.Value = True Then
Call MsgBox("Your message goes here&quot
End If

hth
Jeff Bridgham
bridgham@purdue.edu