I have a form designed, and so far everything is working perfectly, except for being able to update the checkboxes from whatever state they were in to begin with.
When I click on a checkbox, I want it to update a certain field in the table with an x if it's True, or nothing if it's False (checked or unchecked).
This is the code I've been using, but it's giving me an error.
Private Sub chk_Mem_Click()
If chk_Mem = True Then
Set Combo1.Column(3) = "x"
i = 1
Else
Set Combo1.Column(3) = ""
i = -1
End If
Set Combo1.Column(8) = Combo1.Column(8) + i
txtHol = Combo1.Column(8)
End Sub
Can anyone help me out?
When I click on a checkbox, I want it to update a certain field in the table with an x if it's True, or nothing if it's False (checked or unchecked).
This is the code I've been using, but it's giving me an error.
Private Sub chk_Mem_Click()
If chk_Mem = True Then
Set Combo1.Column(3) = "x"
i = 1
Else
Set Combo1.Column(3) = ""
i = -1
End If
Set Combo1.Column(8) = Combo1.Column(8) + i
txtHol = Combo1.Column(8)
End Sub
Can anyone help me out?