Auto checkbox check on button event

  • Thread starter Thread starter Ladybird
  • Start date Start date
L

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



jl5000 said:
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>


Ladybird said:
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.
Click to expand...
Click to expand...
 
Back
Top