Mass mark check boxes as True

[boatman37210]

I have a form where I need to mark a check box as true if another check box on the form is true. This only needs to occur each time a procedure is run. Nothing needs to happen automatically if I go in and change a record. It would need to be a procedure I run once I'm done performing any maintenance to the records. Hope this makes sense.

I could view each record and do it manually, but I have over 1,600 records and was hoping there was an easier way.

Checked the forum, but could not find anything that fit what I need to do. There probably is, but could not find it.

Thanks for any help.

 

[Access_guy49]

make an update query.
Update Checkbox 2 to equal 0 (checked)
and set the criteria of checkbox 1 to equal 0.

Likewise you could run another query that does the opposite. when both queries are run, it will have updated a total of all the records in your database.

 

[Moniker]

Setting a checkbox to 0 will uncheck it, not check it as you stated. Changing it to -1 will check it. Alternatively and for clarity, you can change it to the literal word True (no quotes) and that will check it as well. False is the reverse of that.

 

[Access_guy49]

Setting a checkbox to 0 will uncheck it, not check it as you stated. Changing it to -1 will check it. Alternatively and for clarity, you can change it to the literal word True (no quotes) and that will check it as well. False is the reverse of that.

LOL YES! my mistake (sorry about that!) Thank you for catching that one! boy is my face red!