Retrieve Value of Grouped Radio Button

[Proaccesspro]

I have 2 radio buttons on a form...I need to know which was selected by the user in order to determine which report to send to the printer....This code is NOT getting it done...Any ideas??


If Forms!ReportForm![Option68].Value = True Then

[Delerna]

I think its

If Forms!ReportForm![Option68].checked= True Then


By the way, get in the habbit of giving your controls sensible names.
It will make your code more readable and therefore easier to understand and change latter. Are you going to remember what Option68 is in 12 months after you relese it for use and a user encounters a problem has occurred and you need to track down what is causing it. A3 letter prefix in the name also tells you the type of control you are dealing with

optNameOfTheOptionControl
btnNameOfTheButtonControl
frmNameOfTheForm
tblNameOfTheTable
qryNameOfTheQuery

Just a suggestion !!

[missinglinq]

An Option Group isn't boolean, it doesn't return True/False. Instead, an Option Group returns the value assigned to the given button/checkbox. The first item in the Group returns a 1, the second a 2, and so forth. If the name of your Option Group frame is YourOptionFrame (clever isn't it?) this code will do the trick:

Private Sub YourOptionFrame_Click()
 Select Case YourOptionFrame
   Case 1
    'Code here to print "Report1"
   Case 2
    'Code here to print "Report2"
 End Select
End Sub
 

You could also use

Private Sub YourOptionFrame_Click()
   If YourOptionFrame = 1 Then
     'Code here to print "Report1"
  ElseIf YourOptionFrame = 2 Then
      'Code here to print "Report2"
  End IF
 End Sub
 

With just a couple of choices it probably doesn't matter which you use, but the first example, using the Select Case construct, makes things much clearer when you have a number of choices.

You could use the same code behind a command button, to be clicked after chosing a button.

BTW, Delerna's advice on giving meaningful names to controls is spot on!

Linq ;0)>

[Proaccesspro]

An Option Group isn't boolean, it doesn't return True/False. Instead, an Option Group returns the value assigned to the given button/checkbox. The first item in the Group returns a 1, the second a 2, and so forth. If the name of your Option Group frame is YourOptionFrame (clever isn't it?) this code will do the trick:

Private Sub YourOptionFrame_Click()
 Select Case YourOptionFrame
   Case 1
    'Code here to print "Report1"
   Case 2
    'Code here to print "Report2"
 End Select
End Sub
 

You could also use

Private Sub YourOptionFrame_Click()
   If YourOptionFrame = 1 Then
     'Code here to print "Report1"
  ElseIf YourOptionFrame = 2 Then
      'Code here to print "Report2"
  End IF
 End Sub
 

With just a couple of choices it probably doesn't matter which you use, but the first example, using the Select Case construct, makes things much clearer when you have a number of choices.

You could use the same code behind a command button, to be clicked after chosing a button.

BTW, Delerna's advice on giving meaningful names to controls is spot on!

Linq ;0)>

Thanks, Guys! I'll incorporate the changes!