[MS_AccessPros] Problem with checkboxes randomly disappearing

 

I had an issue with two checkboxes randomly disappearing on a form in MS Access 2003. What I am trying to do is if a person passes an eye exam, the chkPassEyeMRR is checked so I don't want to see the chkFailEyeMRR checkbox.

Below is the code I am using in the "On Current" event.

'Hides checkboxes if one of the other check boxes are checked.
If [chkPassEyeMRR] = True Then
[chkFailEyeMRR].Visible = False
ElseIf [chkFailEyeMRR] = True Then
[chkPassEyeMRR].Visible = False
Else
[chkPassEyeMRR].Visible = True
[chkFailEyeMRR].Visible = True
End If

When I open the form, the pass or fail checkbox displays properly. However, as I move from record to record, the checkboxes randomly disappear and reappear.

I have similar code for different controls on a separate tab on the same form and that code works and the textboxes display properly.

Any idea what is going on and how I can fix the issue?

John F

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___