Run a macro

O

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
 
S

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.
 
P

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.
 
Top