I have some code that runs however when run it keeps asking for a value for ME.Text35?
strWhere = "WHERE Descriptions.[Functional Alignment]In ("
If Me.GetFunctionalAlignment.ItemsSelected.Count > 0 Then
For Each varItem In Me.GetFunctionalAlignment.ItemsSelected
strCriteria = strCriteria & ",'" & Me.GetFunctionalAlignment.ItemData(varItem) & "'"
Next varItem
strCriteria = Right(strCriteria, Len(strCriteria) - 1)
strCriteria = strWhere & strCriteria & ")"
strCriteria = strCriteria & " AND [Raw Data].[Age of Claim]>= " & _
Me.Age_GT_Text25 & " And [Raw Data].[Age of Claim] <= " & Me.Age_LT_Text27
If Me.CmbClaimFilter = "Pend" Then
strCriteria = strCriteria & " AND NOT [Raw Data].[User Id] = " & Me.Text35 & _
" AND NOT [Raw Data].[User Id] = " & Me.Text35 & ";"
strSQL = strTempSQL & strCriteria