Run A Query When A Checkbox Is Checked

G

Guest

I would like to run a query when a checkbox is checked but if I un-check the
box the query does not run.

Any help will be appreciated.

Regards
Nick
 
A

Al Camp

Nick,
Use the AfterUpdate event of the checkbox...
If YourChkBoxName = True the
'run query here
End if
 
G

Guest

Thanks for your help Al.
I used Private Sub D_AfterUpdate()
If D = True Then
run query qyCompleteContinuations
End If
End Sub
However I couldn't get it to work and I also tried
DoCmd.OpenQuery qyCompleteContinuations

I am obviously doing something basically wrong?
 
A

Al Camp

Nick,
However I couldn't get it to work...
Click to expand...
I'm surprised you didn't get some error message. Always include any error messages
when posting...

You should be using...
DoCmd.OpenQuery "qyCompleteContinuations"
or...
DoCmd.RunSQL "....The SQL string of your qyCompleteContinuations here......"
 
G

Guest

Thanks again Al,
I actually didn’t get any error messages. The query just would not work but
now I have used “ “ around the query name it works fine.

Your help is appreciated
Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

checkbox on form not working 2
checkboxes that are "synchronized" but don't want that behavior 2
datestamp with a check box 2
Page visible when check box marked 2
Select Case help needed 2
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
Check box on a subform 1
Auto checkbox check on button event 2

Top