G
Guest
I use a form with check boxes. I currently have code that If one box is
checked
Then change a list to "1"
Private Sub XXX_AfterUpdate()
If (Me.XXX = -1) Then
Me.List117 = "1"
End If
I want to write a code that if two (or more) boxes are checked Then
change list to 2
I tried this but it didn't work
Private Sub XXX_AfterUpdate()
If (Me.XXX = -1) and
If (If Me.YYY = -1 ) Then
Me.List117 = "2"
End If
I would appreciate any help.
checked
Then change a list to "1"
Private Sub XXX_AfterUpdate()
If (Me.XXX = -1) Then
Me.List117 = "1"
End If
I want to write a code that if two (or more) boxes are checked Then
change list to 2
I tried this but it didn't work
Private Sub XXX_AfterUpdate()
If (Me.XXX = -1) and
If (If Me.YYY = -1 ) Then
Me.List117 = "2"
End If
I would appreciate any help.