can a check box be part of an option AND have a control source?

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

I have 3 options that only one can be selected at a time. I then want to be
able to keep this as a record as currently, when I exit my form, the options
are not remembered and i want to keep of record of them in the table my form
is based on, can this be done?
 
No. An option group has a control source, which you can set to a Number
field. The controls in the option group cannot have a Control Source of
their own.

If you have 3 x Yes/No fields in your table, but only one of them should be
selected at one time, you must not use 3 separate Yes/No fields. Use one
Number field instead.
 
Your check boxes would have to be part of an option group. You field could
not be a Yes/No field because an option groups returns a numeric integer
value based on which option is selected regardless of whether it is a check
box or a button.

Make your field a numeric integer field.
Create an option group and add 3 check boxes (I prefer buttons, but check
boxes work) and assign each a numeric value
bind the control to the field.
It will then store the value based on the selection in the option group.
 
Back
Top