Dim filter As String = Tables("采购汇总").Filter
Tables("采购汇总").Filter = iif(filter>"", filter & " and ", "") & "供应商名称 like '*"& gys.Text & "*'"