Glad you got it working!

If I understand you correctly, you are using an unbound option group to update a bound textbox control. Your code appears to update the table value for Q1_Response, but not the option group. Each radio in the option group has a value and this value is not being updated. Add something like:
[option group name] = "N"

Would it not be easier to create a bound option group so it stores your selection? In design view, click...