Radio Button Value in Option Group

[Chuck]

I am trying to change the record source for a report,
depending on which radio button is selected in an option
group.

--------------------------------------------------------
If (Forms!frmReports!FrameSO!optBuyer.Value = True) Then
Reports!rptStndOrder.RecordSource = "zqryStndOrderB"
else
Reports!rptStndOrder.RecordSource = "zqryStndOrderC"
End If

 

[Jeff Frent]

I am trying to change the record source for a report,
depending on which radio button is selected in an option
group.

--------------------------------------------------------
If (Forms!frmReports!FrameSO!optBuyer.Value = True) Then
Reports!rptStndOrder.RecordSource = "zqryStndOrderB"
else
Reports!rptStndOrder.RecordSource = "zqryStndOrderC"
End If

I think you may have more than one problem...

#1 - Normally you would use the value of the Frame, not the radio buttons

Ex:
Select Case Forms!frmReports!FrameSO
Case 1 'This is assuming that 'Buyers' is #1
Reports!rptStndOrder.RecordSource = "zqryStndOrderB"
Case else
Reports!rptStndOrder.RecordSource = "zqryStndOrderC"
End Select

#2 - I believe that you have to have a report in Design mode to change the
record source. Are you sure there isn't a better way to handle that on the
fly? Perhaps using different reports to handle your different situations?

 

[Cheryl Fischer]

Did you use the Control Wizard to create your option group? If so, it
assigns numeric values to the options by default: 1, 2, 3, etc.

 

[Chuck]

Cheryl, I did use the Control Wizard to create my option
group. Jeff, I was testing the if then else
functionality to get it to work, but planning to
implement the Case Select structure (due to have three
different queries). I currently have 3 versions of the
same report 5x (total of 15). I am looking at the radio
group functionality to remove 10 reports. This will
enable the user to select the report and filter with
desired radio button/query. Thank you both for your
quick responses.

 

[Jeff Frent]

Cheryl, I did use the Control Wizard to create my option
group. Jeff, I was testing the if then else
functionality to get it to work, but planning to
implement the Case Select structure (due to have three
different queries). I currently have 3 versions of the
same report 5x (total of 15). I am looking at the radio
group functionality to remove 10 reports. This will
enable the user to select the report and filter with
desired radio button/query. Thank you both for your
quick responses.

Chuck,

If filtering is what you need, you can do that on the fly. If I can make a
couple of assumptions:
#1 - Your structure behind all of the reports must be the same, correct?
Built from the same table or query with different critieria (i.e.
Jobcode="Buyer" or Jobcode = "Seller"?

If that is the case then you can use the select command or the IFelse
command and come up with different criteria for a single report.

Ex
Dim stLinkCriteria as string
Const stDocName = "ReportWithEverything"

Select Case FORM!Option
Case 1 'Buyer'
stLinkCriteria = "JobCode='Buyer'"
Case 2 'Salesperson
stLinkCriteria ="JobCode='Salesperson'"
End Select

DoCmd.OpenReport stdocname, acViewPreview, , stLinkCriteria

Maybe that will help?