By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,743 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,743 IT Pros & Developers. It's quick & easy.

Getting values from radio button group.

P: n/a
Hi all,

I have a small problem with Access radio button groups in VBA. I've got a
radio button group called fraSearchMode with three radio buttons in it. At a
certain point, I want to see which radio button is selected and store the
value (1, 2 or 3) in a Byte variable. Now, I assumed that this was a simple
case of choosing the button you wanted and checking the fraSearchMode.Value
property for value 1, 2 or 3. Apparently this is not so. :)
I've tried searching the net for info on this and come up with nothing (not
many resources for Access VBA....loads on Excel) and my Office Help is
playing up. Can somebody tell me how to get the currently selected radio
button in a group, please?

Thanks!

Jon.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
HJ
Your code is correct. Me.fraSearchMode.Value represents the currently
selected radio button. Make sure that your option buttons are part of the
option group.

HJ

"Rage Matrix" <ra**@matrix13.freeserve.co.uk> wrote in message
news:bi**********@newsg4.svr.pol.co.uk...
Hi all,

I have a small problem with Access radio button groups in VBA. I've got a
radio button group called fraSearchMode with three radio buttons in it. At a certain point, I want to see which radio button is selected and store the
value (1, 2 or 3) in a Byte variable. Now, I assumed that this was a simple case of choosing the button you wanted and checking the fraSearchMode.Value property for value 1, 2 or 3. Apparently this is not so. :)
I've tried searching the net for info on this and come up with nothing (not many resources for Access VBA....loads on Excel) and my Office Help is
playing up. Can somebody tell me how to get the currently selected radio
button in a group, please?

Thanks!

Jon.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.