Never Ending If-Then-Else............

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

Guest

Morning........ I have 6 check boxes in a form, user selects only one to
print the corresponding report. Want to make sure only one box is selected,
not 2,3, etc. It's a probability thing I used an IF for when I had 3
boxes........... now with 6 boxes........... I'll fill a page to confirm 1
box. Remember a "Case" statement in my VB Plus class............... can I do
something like that?
 
Use an option group instead. Drop six check boxes onto it (so that the
group turns black while you're dropping). Check/set the option value of
each of those check boxes (Access will automatically apply 1 to 6 to them)
and you can then use me.OptionGroupControlName to decide which one is
ticked.
 
Rob is correct, however, just a point on standards here if you don't mind.

Option boxes are for selecting mutually exclusive options, whereas Check
boxes are for selecting yes/no or true/false conditions. So in this case, to
maintain a Windows-standard interface, you should use Option Boxes, not
Check Boxes.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
 
Quite right. No point in potentially confusing users by using non-standard
controls. Thank you for the correction.
 
Back
Top