Dim t As Table = Tables("窗口1_Table1")
With Tables("客户")
If .Current Is Nothing Then
t.Filter = "False"
Else
t.Filter = "城市 in ('" & DataTables("客户").GetComboListString("城市", "城市 = '" & .Current("城市") & "'").replace("|", "','") & "')"
End If
End With
vars("filter") = t.filter
-------------
Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("窗口1_Table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "'%" & txt & "%'"
tbl.Filter = vars("filter") & " and (客户ID Like " & txt & " Or 公司名称 Like " & txt & " Or 地址 Like " & txt & " Or 联系人 Like " & txt & ")"
End If
[此贴子已经被作者于2019/6/21 16:33:43编辑过]