Getting values from radio button group.

[Rage Matrix]

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

[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