Can I setup two checkbox so that you can only check one at a time

[JonH]

I have two fields, both which are yes/no checkbox's. However, for query
purposes on a form, I would like the user to be able to only choose one of
the checkbox's at a time (on a form), preventing them from checking both and
having two many results show up. Is there some sort of expression/macro that
will allow this? Using the option box will not really work for me in this
case since its two different fields.

Thanks!

 

[Douglas J. Steele]

You can put them in an Option Group, or you can put code in their
AfterUpdate events:

Private Sub Check0_AfterUpdate()

Me.Check1 = Not Me.Check0

End If

Private Sub Check1_AfterUpdate()

Me.Check0 = Not Me.Check1

End If