Record Option Group Selection in Another Table

[ilcaa72]

I am trying to create an exam application. The questions, choices, correct answers, and explanation are in 1 table. I created a 2nd table to record the responses to each answer and deliver a score at the end of the exam.

When i try to use Option Group the only option to store the result is in the table where the questions are coming from (the Forms Record Source), what the best way to know which option was selected a place that into a new Table? thanks for any guidance

 

[Ranman256]

this is the problem with options. They have to be manually made. Others like combo box, list box are auto updated by values in a table. Option buttons have to manually assigned and the target field set in the frame.

you have 2 sources, 1 is the list of options to pick from, (options, combo list items)
and 1 is where to store the answers. This is the table bound to the form.

 

[Uncle Gizmo]

I have an example on my website for creating a checklist Here:-

https://sites.google.com/site/msaccess457966vmfjg/advanced-techniques/check-lists

There are also a set of videos showing how to set it up.

The example shows a checkbox. I also show how to use the same system with a text box. I haven't tried an option group yet.

 

[ilcaa72]

Ranman: i was going to leave the Option Control with A, B, C, D and just place textbox over the control to show the various answers to choose from. the issue i am having is storing the answer selected into another table...


Gizmo: thanks, the presentations seem thorough. i look into it in more details. So the only way to accomplish this is through VBA? i dont mind, i am good with Excel VBA i assume Access will be easy to pick up...