主题：filter 总是迷糊

遇到这种稍微变化一些的filter，就迷糊了。
下面是我的问题：筛出来的结果总有问题。

三个text，一个table，前一个是完全匹配，后两个是模糊匹配，只要满足一个，就把结果筛出来。

Dim Filter1 As String
Dim Filter2 As String
Dim Filter As String
Dim txt1 As String = e.Form.Controls("TextBox1").Text
Dim txt2 As String = e.Form.Controls("TextBox2").Text
Dim txt3 As String = e.Form.Controls("TextBox3").Text

txt1 = "'%" & txt1 & "%'"
Filter1 = "编号 = " & txt1

txt2 = "'%" & txt2 & "%'"
txt3 = "'%" & txt3 & "%'"
Filter2 = "(产品名称 Like " & txt2 & " or 运输名称 Like " & txt3 & ")"

Filter = filter1 & " or " & filter2

Dim dr As DataRow
With DataTables("ProductInformation")    
    
         .LoadFilter = Filter
    .Load
    dr = .Find(Filter)

End With