ACCESS VBA: Transfer value of radio button on form to table field


I have an option group on a form that has 3 radio buttons, each with a different value.
I am trying to send the actual value of the radio buttons to a field in a table when the user selects a radio button.
The value could be an assigned value since they don't change.

What would be the code in VBA that could do that?

Any ideas? thanks for your help.

Who is Participating?

Improve company productivity with a Business Account.Sign Up

p912sConnect With a Mentor Commented:
Is the form that the radio button is on linked to the table that will store the value? If it is then set the Control Source for the Frame/Option Grooup to the field that should store the value.

Hope that helps.



Assuming the Group is called Group1, and each of these buttons have a value, assuming 1,2 and 3

"On Click" [Event Procedure] of Group1 have this code:

if Group1=1 then
 xyz="button one"
if Group1=2 then
 xyz="button two"
 xyz="button three"
end if

you should place the same code "On Load" of the Form too.

xyz is your control on the Form, which is bound to the field in the Table,

sorry, for the "On Load" the code should be the other way around:

if xyz="button one" then
if xyz="button two" then
end if
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

MonteCristo33Author Commented:
Hi Scot,

the best solutions are always the simplest ones. It works like a charm, thank you very much for your help.

MonteCristo33Author Commented:
Hi Jaffer,

Thank you very much for your contribution. I was already using a similar Case statement based on my option group to enable/disable textboxes. My real difficulty was updating the corresponding field in the linked table, which Scot helped resolve.

As I am working on several projects at the moment, no doubt your knowledge will come in handy at some point.

Thanks again for taking the time to help.


You're most welcome, glad to help. And thanks for the points and grade.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.