Dim tns() As String = {"表A", "表B"} For Each tn As String In tns Dim filter As String = "1=2" For Each dc As Col In CurrentTable.Cols filter &= " or convert(" & dc.Name & ",'System.String') like '%" & e.Form.Controls("TextBox1").Text & "%'" Next Tables(tn).Filter = filter Next