Getting values from radio button group.

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rage Matrix
    #1

    Getting values from radio button group.

    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.V alue
    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


    Tags: None
    • HJ
      #2
      Re: Getting values from radio button group.

      Your code is correct. Me.fraSearchMod e.Value represents the currently
      selected radio button. Make sure that your option buttons are part of the
      option group.

      HJ

      "Rage Matrix" <rage@matrix13. freeserve.co.uk > wrote in message
      news:biokjk$6kr $1@newsg4.svr.p ol.co.uk...[color=blue]
      > 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[/color]
      a[color=blue]
      > 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[/color]
      simple[color=blue]
      > case of choosing the button you wanted and checking the[/color]
      fraSearchMode.V alue[color=blue]
      > 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[/color]
      (not[color=blue]
      > 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
      >
      >[/color]


        Comment

        Previous template Next
        Working...