Ticking only one check box in a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 5 check boxes in a record and I want to be able to limit input of data so that only one check box can be ticked. It's probably really straight forward, but can't find out through the usual help menus. Is it a validation rule expression, maybe?
Would really appreciate help.
Thanks ...
 
This sounds like an issue with your table structure. If I had 5 yes/no
fields that should only allow one selection, I would use a single field. My
forms would use an Option Group to select the one value. Is it possible for
you to change your table structure?

Otherwise, I suppose you could write a function in your data entry form that
would check the current control (check box) to see if it is True/Checked. If
it is, then set the other check boxes to false.

--
Duane Hookom
MS Access MVP
--

Marian said:
I have 5 check boxes in a record and I want to be able to limit input of
Click to expand...
data so that only one check box can be ticked. It's probably really
straight forward, but can't find out through the usual help menus. Is it a
validation rule expression, maybe?
 
Back
Top