Storing the selected Checkbox option in the MS Access Database. (1 Viewer)

Hi,


How can I store the value of the selected checkbox option in the Ms Access Database?

I had a Combo Box in my form as it's shown in the image. I'll have to change it to Checkbox like it's shown below the Combobox. The options in both checkbox and the combobox are same. If an option is selected from the Combobox, the value is getting stored in the database but it's not getting stored when I select the checkbox option. Should I have to create fields in table for each option mentioned in checkbox and specify the type as Yes/No? or is there any other way?

Hi. You said the values are the same between the combo and checkboxes. Does that mean they should be stored in the same field in your table? If so, you could use an Option Group for the checkboxes and bind it to the same field as the combobox.

No, I don't want the combobox. Instead of combobox, I'm asked to change it to checkbox. When the user selects a checkbox option, the value should get stored in the MS Access. How do i do that?

like what was said, use Option Group control instead of individual checkboxes.
add the field you want the value of your Option Group to be saved to your table.
set it's Visible property to No, on design view.

in the AfterUpdate event of your Option Group add code: