Checkboxes and BeforeUpdate Event

[MrYoda1]

I’m trying to work out some VBA code to test the condition/value of a couple of checkboxes. I want this code to run in the BeforeUpdate event. I found something similar, just not similar enough.

https://stackoverflow.com/questions/3813760/determine-whether-a-access-checkbox-is-checked-or-not

Here’s what I’m playing with. I have four checkboxes.

chkCheckBox1
chkCheckBox2
chkCheckBox3
chkSomethingIsChecked

The Tag property for the first three checkboxes has been set to “ABC”

Here is the original code I was trying:

Dim ctrl As Control
For Each ctrl In Me.Controls
    If ctrl.Tag = "ABC" Then
        If ctrl.Value = True Then
            chkSomethingIsChecked.Value = True
        Else
            chkSomethingIsChecked.Value = False
        End If
    End If
Next ctrl

I realize this won’t work because it would seem that whatever the condition of the first two checkboxes it is only the condition of the last checkbox that determines if chkSomethingIsChecked is true or false.

Next, I tried:

Dim ctrl  As Control
Dim CheckBoxCount as Integer
 
    For Each ctrl In Me.Controls
        If ctrl.Tag = "ABC" Then
            If ctrl.Value = True Then CheckboxCount = CheckboxCount + 1
        End If
    Next ctrl
 
    If CheckboxCount > 0 Then
        chkSomethingIsChecked.Value = True
    Else
        chkSomethingIsChecked.Value = False
    End If

This didn’t work, either. So, I put the code in a Command Button and tried it. It worked perfectly.

That leads me to ask is there something about the BeforeUpdate event that is different than a Click event and causes this code to fail?

[jforbes]

What you are experiencing makes perfect sense. From MSDN, BeforeUpdate:

The BeforeUpdate event occurs before changed data in a control or record is updated.

So as you are iterating through the controls and inspecting their values, they haven't changed yet. They are in the process of changing and you have the option to cancel their changes. Typically, the BeforeUpdate event's best use is for validation of the Value.

Your code should work if you move it to the AfterUpdate Event.