G
Guest
I wanted to see if I can get the functionality of an option group by
programming check boxes [check box "Answer" is bound to a yes/no field, and
check box "CheckNo" is unbound], and it is indeed possible and pretty simple
- I just attached a couple of lines of code to the AfterUpdate event of both
check boxes so that when one is checked, the other becomes unchecked.
The problem I have is that when I load the form, and the bound form is
checked, the unbound form is not empty. I was trying to use the code below to
clear the field if necessary, but it's not producing the desired result, ie
when the default value of the check box was "true", it was checked even when
the other check box was checked, and now that there's no default value, it's
grey instead of white.
What needs to
Private Sub Form_Load()
If Answer = -1 Then
CheckNo = 0
End If
End Sub
programming check boxes [check box "Answer" is bound to a yes/no field, and
check box "CheckNo" is unbound], and it is indeed possible and pretty simple
- I just attached a couple of lines of code to the AfterUpdate event of both
check boxes so that when one is checked, the other becomes unchecked.
The problem I have is that when I load the form, and the bound form is
checked, the unbound form is not empty. I was trying to use the code below to
clear the field if necessary, but it's not producing the desired result, ie
when the default value of the check box was "true", it was checked even when
the other check box was checked, and now that there's no default value, it's
grey instead of white.
What needs to
Private Sub Form_Load()
If Answer = -1 Then
CheckNo = 0
End If
End Sub