If e.Col.Name = "品名规格" Then \'如果编辑的是品名规格列
If e.Col.DroppedDown Then \'如果下拉窗口已经打开
Dim tbl As Table = Tables("下拉窗口_意和表")
If e.Text = "" Then \'如果内容为空
tbl.Filter = "客户=\'" & e.Row("客户") & "\'" \'显示所有客户
Else \'否则根据输入内容进行模糊筛选
Dim txt As String = "\'%" & e.Text & "%\'"
\' tbl.Filter = "品名规格 Like " & txt & " Or 公司名称 Like " & txt & " Or 地址 Like " & txt & " Or 联系人 Like " & txt
tbl.Filter = "品名规格 Like " & txt & " and 客户=\'" & e.Row("客户") & "\'"
End If
End If
End If