New user.. How do I reset the value of a check box

[JDonnelly21]

Access 2007.. I have a check box in a form that I wish to reset using a command button. How do I achieve this or is there a more efficient way to make this happen?


Thanks!

[alansidman]

When you say reset, is this what you mean?

If it is checked and you click the command button it will uncheck and
If it is unchecked and you click the command button it will become checked?

If your answer is yes, then your code for the command button would be:

If me.checkboxname.value = -1 then
me.checkboxname.value = 0
Else
If me.checkboxname.value = 0 then
me.checkboxname.value = -1
End if
End if

Change checkboxname to what your control is named

[JDonnelly21]

I am looking to reset (uncheck) all values in the form / table that are checked. The solution works on resetting the current row selection only. How do I execute this at the table level?

[alansidman]

You will have to do that through an update query. BTW: In your original post you spoke of a form. No mention that you wished to do this in a table. Sorry, I left my crystal ball at home and couldn't figure that out for you.

Look here:

http://www.youtube.com/watch?v=--PVVLIcbjE

Alan

[JDonnelly21]

Thank you for the quick response...

I am looking to reset (uncheck) all values in the form / table that are checked. The solution works on resetting the current row selection only. How do I execute this at the table level?

Thanks again for your help!

[JDonnelly21]

That worked... Thanks for your assistance... I'll work on including more detail in my requests for help for the next time...