Take OptionValue from option group to check a box in a table's appropriate field?

[funwithaccess]

Hi all!

I was wondering if there is a way to take the selected OptionValue from an option group on a form and have that value check a box in different fields on the bound table instead of just placing a value in one single field.

For example, I have a form that users will use to report technical issues of an application. On the form I have one option group of 6 options. Currently, the option group sends the selected value (1 - 6) into only one field (created using Control Wizard). Instead, I would like it to take the value of let's say "2" and check a box that is dedicated only in field 2 in the table, or if you select "6" it only checks the box for the field named "6". Is there a way to do that in VBA? I have no idea where to start.

BTW, I'd like to thank you for the amazing support that the members of this forum provide! I have learned more from Access-Programmers than any other resource online or in print.

Thanks,
Nate

 

[CJ_London]

Can you provide a bit more background?

Such as the field names, why you want to do it this way rather than a checkbox for each field or why you don't just use the value in the optionbox, how you plan to populate with the existing option for existing records etc.

I suspect there is simpler way

 

[funwithaccess]

The names of the fields will be Template, Skim, Printer, CI, Priority, Other.

I want the user to select only one option and not multiple options. It is my understanding that the checkbox option is not setup to function that way.

The reason that I do not want to use the option value in a single, universal field is because there will be multiple people that will query this table and seeing only a number may confuse them. It would be ok, however, to have the value appear in the specified field instead of checking a box.

Example:
The user selects Template, the optionvalue for Template is 1, then the number 1 appears in the Template field of the table.

Or

If the optionvalue for Printer is 3, then the number 3 appears in the Printer field of the table.

This would be fine since the value at least appears in the corresponding field.

Also, if there is an easier way to do this I am all ears!

 

[CJ_London]

If other users are creating queries on your table, you should educate them properly as to the table contents. If they are using queries and/or forms that you have developed then use the choose function within your query and/or form recordsource.

Choose(OptionGrp,"Template, "Skim", "Printer", "CI", "Priority", "Other")

Alternatively still have the single field and on your form have a combobox to lookup these values from a small table instead of using an option group.

 

[funwithaccess]

Hi CJ,

I apologize for the long delay. I ended up being pulled into a whole different direction on a different project. The way that I ended up going was using the combobox, that way we can modify the values if we need to and not affect the user. Thanks for your help!

Nate