Dim filter As String = "1=2"For Each dc As Col In Tables("价格表").Cols Filter &= " or Convert(" & dc.Name & ",'System.String') like '%" & e.Form.Controls("TextBox1").Text & "%'"Next
Tables("价格表").Filter = filter