Option Button in MS Access 1

[ineedyourhelp]

I have two check boxes in my form (named as below).

In Progress
and
Completed

I would like the user to check one, but I do not want them to be able to have both checked at the same time. I would like the check mark in the In Progress box to disappear when Completed is selected (and vice versa)

Any help would be much appreciated.

Thanks!!

 

[zemp]

First off I would recommend using option (or radio) buttons instead of Check boxes. That way your issue is resolved automatically.

If you must use check boxes try this in the click events.

Private Sub Check1_Click()
   Check2.Value = Abs(CInt(Not CBool(Check1.Value)))
End Sub

Private Sub Check2_Click()
   Check1.Value = Abs(CInt(Not CBool(Check2.Value)))
End Sub

zemp

 

[ineedyourhelp]

Fantastic!! Thank you.