Run a macro

[Osyris]

hi all..
i need a little help

i have create a macro that when it runs it sends an email to a user..

what i want is a querry to do the following
when a check box is checked then run the macro..
eg
if checkbox=true then
[ run macro ]

hpw can i do this?

thanx

 

[Tom Wickerath]

Hi Osyris,

Does this help?

If Me.CheckBoxName = True Then
DoCmd.RunMacro "NameOfMacro"
End If


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Steve Schapel]

Osyris,

In design view of your macro, enter the equivalent of this in the
Condition column:
[NameOfYourCheckbox]<>0

If you can't see the Condition column, select it from the View menu.

 

[Pat Hartman]

Queries don't have events so you would need to create a form. You can then
add the suggested code to the AfterUpdate event of the checkbox.