(Solved) – Filtering another form based on fixed value


Having issues with the below code when I try and add a 2nd condition which is looking for a fixed text string in the Status field. Error is 2465 “Can’t fing the field ‘l1’ referred to in your expression.

Private Sub Work_In_Progress_Click()
    Dim strFilter As String
    strFilter = "[Category] =" & Chr(39) & Me.Category.value & Chr(39) And [Status] = "work In Progress"
    Forms("f_ADb_Changes").Filter = strFilter
    Forms("f_ADb_Changes").FilterOn = True
End Sub

Leave a Reply

Your email address will not be published. Required fields are marked *