Setting Query Criteria using Iif Statement

[thexxvi]

Good afternoon,

I currently have a query and a form. The form has three radio buttons (ListeningReviewOption, TargetReviewOption, and BothOption). I am attempting to set the criteria in a query based on the radio option the user selects in the form. If they select ListeningReviewOption, I want the criteria to show "Listening Review". If they select TargetReviewOption, I want the criteria to show "Target Review". I can do both of those with an IIF statement, but I'm having trouble showing both the "Listening Review" and "Target Review" if BothOption is selected. Any thoughts on how I would accomplish this task?

Thank you,

Cory

[ranman256]

radio button ONLY have 1 option. no more.
otherwise you must use check boxes.

[June7]

I NEVER use dynamic parameterized query. I prefer VBA to build criteria and set filter for form or report. Review: http://www.allenbrowne.com/ser-62.html

Are these radio buttons within an Option Group control?

Post your working expression.

[thexxvi]

I'm using this IIF statement:

IIf([Forms]![Summary Page]!
[ListeningReviewOption]=True,"Listening Review",IIf([Forms]![Summary Page]![TargetReviewOption]=True,"Target Review",IIf([Forms]![Summary Page]![BothOption]=True,"Like "*"")))

I know it's close but can't get the syntax right for [BothOption]

[thexxvi]

June7, I appreciate your post but I don't think that's going to help in this scenario.

[June7]

So these radio buttons are not within an Option Group? They should be to allow only one of the buttons to be selected.

Problem is the operator (=, Like, etc) cannot be dynamic and cannot be within quotes because then it's just a string, not an operator. So maybe:

LIKE Switch([Forms]![Summary Page]!
[ListeningReviewOption] = True, "Listening Review", [Forms]![Summary Page]!
[ListeningReviewOption] = True, "Target Review", [Forms]![Summary Page]!
[ListeningReviewOption] = True, "*")

[thexxvi]

I can make it so that they're within an Option Group, but they're not currently like that (I didn't realize that was an option as I am just a beginner with MS Access). Instead, I have VB code written out the long way to ensure this:

Private Sub ListeningReviewOption_Click()
If Me.ListeningReviewOption = True Then
Me.TargetReviewOption = False
Me.BothOption = False
Me.Refresh
End If
End Sub
Private Sub TargetReviewOption_Click()
If Me.TargetReviewOption = True Then
Me.ListeningReviewOption = False
Me.BothOption = False
Me.Refresh
End If
End Sub
Private Sub BothOption_Click()
If Me.BothOption = True Then
Me.TargetReviewOption = False
Me.ListeningReviewOption = False
Me.Refresh
End If
End Sub


I'll give your suggestion a try. Thank you.

[thexxvi]

June7, you're a genius. Thank you so much for your help!