[RESOLVED] Getting subsequent filters to not affect original filters

[jmcilhinney]

The Filter expression is basically a SQL WHERE clause. Just like in a WHERE clause, if you want to use multiple criteria then you have to AND and OR them together in the appropriate manner. If you want to filter out records other than those WHERE Turbo is LIKE one value AND Make is LIKE another then that's exactly what you have to put in your Filter expression.

If the criteria might change dynamically then the best way to build the complete expression is to create a List containing the subexpressions and then Join them together with ANDs between them, e.g.

Dim criteria As New List(Of String)
 
If x Then
    criteria.Add("x = 1")
End If
 
If y Then
    criteria.Add("y = 2")
End If
 
If z Then
    criteria.Add("z = 3")
End If
 
Dim filter = String.Join(" AND ", criteria)

That will give you the correct expression no matter what combination of criteria you use.