Hi there,
I am trying to filter a form using two criteria, one coming from a combobox and the other from a checkbox. Following is what I have come up with but get a Type Mismatch error.

Private Sub cboCompany_AfterUpdate()
  
Me.Filter = "Company = '" & Me.cboCompany & "'" And Me.Filter = "Completed <> '" & Me.Check66 & "'"
Me.FilterOn = True
      
End Sub


Any help with what I am doing wrong would be much appreciated.
Thank.
Tim

---

Answer from Richard Rost:

Try this instead:

Me.Filter = "Company = '" & Me.cboCompany & "' AND Completed <> " & Me.Check66

Your Me.Filter should be just ONE command (the AND is inside the quotes) and a checkbox is treated as an Integer (-1 or 0) not a text string.

PERSONALLY, I prefer changing the RecordSource property using an SQL statement INSTEAD of using Filters.

Me.RecordSource = "SELECT * FROM TableName WHERE Company='" & CompanyName & "' AND Completed<>" & CheckBoxName

That's just my opinion. :)