i ahve a PLCTRacker database that im trying to make search properties work but i cant seem to get it to work right Private Sub RequeryProjNoList()

Dim WH As String
   Dim sql As String
   'Dim X As Integer
  
  
  
    WH = ""
   'Searches the Project Number
    If ProjectNo <> "" Then
        If WH <> "" Then WH = WH & " " & AndOrCombo & " "
        WH = WH & "ProjectNo LIKE '*" & ProjectNo & "*'"
    End If
    'Searches the Technician that worked on the project.
    If Technician <> "" Then
        If WH <> "" Then WH = WH & " " & AndOrCombo & " "
        WH = WH & "Technician LIKE '*" & Technician & "*'"
    End If
    'Searches the Departments Project Numbers
    If Department <> "" Then
        If WH <> "" Then WH = WH & " " & AndOrCombo & " "
        WH = WH & "Department LIKE '*" & Department & "*'"
    End If
    ' Searches the Keyword phrase in notes section
     If Notes <> "" Then
        If WH <> "" Then WH = WH & " " & AndOrCombo & " "
        WH = WH & "Keyword LIKE '*" & Notes & "*'"
     End If
     ' Search Criteria for Begining date
     If DateTo <> "" Then
        If WH <> "" Then WH = WH & " " & AndOrCombo & " "
         WH = WH & "DateEntered <= #" & DateTo & "#"
    End If
    
     If DateFrom <> "" Then
        If WH <> "" Then WH = WH & " " & AndOrCombo & " "
         WH = WH & "DateEntered <= #" & DateFrom & "#"
    End If
    
    If WH = "" Then
        MsgBox "Enter at least one parameter value."
        Exit Sub
    End If
    
    sql = "SELECT ProjectID, ProjectNo, Department, Technician, Notes, " & _
          "DateEntered FROM PLCTracker WHERE " & WH
    ProjNoList.RowSource = sql  ' sets the recordsource to the criteria we enter

---

Reply from Alex Hedley:

If you do a Debug.Print WH what shows in the output window in the VBA Editor?