I've built a search form with 11 different combo boxes and 10 of them work great.  The 11th combo box has different statuses that change depending on the PoP End Date.

Active -  [PoPEnd] >Date()+60
D-60 - [PoPEnd] >Date+30 and [PoP End] <=Date()+60
D-30 - [PopEnd] >=Date() and [PoP End] <=Date()+30
Expired - <Date()

That portion of my SQL string looks like this:

& "IIf([tbl_Charge Codes].[PoP End]>Date()+60,""Active"",IIf([tbl_Charge Codes].[PoP End]>Date()+30 And [tbl_Charge Codes].[PoP End]<Date()+60,""D-60"",IIf([tbl_Charge Codes].[PoP End]>=Date() And [tbl_Charge Codes].[PoP End]<Date()+30,""D-30"",""Expired""))) AS Status, " _
    & "IIf([Status]=""Active"",""1"",IIf([Status]=""D-30"",""2"",IIf([Status]=""D-60"",""3"",IIf([Status]=""Expired"",""4"")))) AS Status_ID " _

My current where clause for the Status_ID looks like this:

If Status_ID <> "" Then
        If WhereStr <> "" Then WhereStr = WhereStr & " AND "
        WhereStr = WhereStr & "Status_ID=" & Status_ID

The form requeries but it doesn't filter by the Status_ID.  All Statuses show up.

Is there a way to do the calculations within the Where Clause for the Status_ID instead of adding it to the "Query" poertion of the SQL statement?