Solved

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

Posted on 2006-11-25
6
1,773 Views
Last Modified: 2007-12-19
Hi,

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.

MC
0
Comment
Question by:MonteCristo33
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 27

Expert Comment

by:jjafferr
ID: 18012075

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"
else
 xyz="button three"
end if

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

jaffer
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 18012085
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
 Group1=1
if xyz="button two" then
 Group1=2
else
 Group1=3
end if
0
 
LVL 18

Accepted Solution

by:
p912s earned 125 total points
ID: 18012092
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.

Scot


0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:MonteCristo33
ID: 18013948
Hi Scot,

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

MC
0
 

Author Comment

by:MonteCristo33
ID: 18013957
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.

MC
0
 
LVL 18

Expert Comment

by:p912s
ID: 18014341
MC,

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

Scot
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question