How to pass values into an IN operator saved query in ms access 2007?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • p4willi
    New Member
    • Jun 2010
    • 22

    How to pass values into an IN operator saved query in ms access 2007?

    How do I pass a set of values into an IN operator without it treating all the values as one string?
    Code:
        If [Forms]![frmList]![cbo_frmlist_as].Value = "ALL" Then
           [Forms]![frmList]![hide_frmlist_as] = "PENDING" & "," & "CLOSED" & "," & "REVIEW"
    The attachment has the saved query.

    Need help - thanks

    p4willi
    Attached Files
Working...