AfterUpdate Event Based on Checkbox

[lisa071]

Hi,
I am trying to hide a certain field based on if a checkbox is checked or not. If the box is checked, the field should be hidden. If the box is not checked, the field should be visible. I have done this before and can't figure out what I am doing wrong now. Here is the code:

Private Sub bxCheck_AfterUpdate()
If bxCheck= "2" Then
Field.Visible = False
Else
Field.Visible = True
End If


End Sub

Please help! I want the field to appear and reappear based on when the box is checked and unchecked.

Thanks.

[ranman256]

Field.visible = boxcheck.value

[ssanfu]

What is the "2"?? You do know there is a difference between a number 2 (no quotes) and a "text" number "2" (with quotes).

That is not the problem here. A check box is either TRUE or FALSE. In Access, FALSE = 0 and TRUE = -1. Actually TRUE = Not FALSE (ie anything other than 0 )

So your code should be:

Private Sub bxCheck_AfterUpdate()
    If bxCheck = True Then    
        Field.Visible = False
    Else
        Field.Visible = True
    End If
End Sub

or

Private Sub bxCheck_AfterUpdate()
    If bxCheck Then
        Field.Visible = False
    Else
        Field.Visible = True
    End If
End Sub

or

Private Sub bxCheck_AfterUpdate()
        Field.Visible = Not (Me.bxCheck)
End Sub

[Missinglinq]

What is the "2"??

I wondered about this, too, and have to ask: Is this an independent Checkbox, or is it one of a series of Checkboxes in an Option Group? I ask because the Controls in an Option Group are not referenced individually...they are referred to by their position in the Group and the name of the Option Group, which Access calls a 'Frame.' If the Frame is named Frame10 and you want to know if the second Checkbox in the Group has been ticked, you'd use something like

If Me.Frame10 = 2 Then

Linq ;0)>