Auto checkbox check on button event

[Ladybird]

I have a continuos form with a run query button & a check box to confirm the
query has been run for the record.
What would be the code for automatically checking off the checkbox upon
pushing the query button.
Thanks.

 

[Guest]

If your run query button is using code, add this line to the On Click event:

me.MyCheckBox=true

If you are using a macro when you click the button add this line in your macro

---Action---
SetValue
Item: [Forms]![FormName]![MyCheckBox]
Expression:True

 

[Ladybird]

Thanks works nice.
I would also like to uncheck all records when the queries have been run -
keeping in mind it is a continuos form with about 35 records.
Thanks

If your run query button is using code, add this line to the On Click
event:

me.MyCheckBox=true

If you are using a macro when you click the button add this line in your
macro

---Action---
SetValue
Item: [Forms]![FormName]![MyCheckBox]
Expression:True


--
jl5000
<a href="http://www.joshdev.com"></a>

I have a continuos form with a run query button & a check box to confirm
the
query has been run for the record.
What would be the code for automatically checking off the checkbox upon
pushing the query button.
Thanks.