Dim Filter As StringWith e.Form.Controls("cmbProduct") If .Value IsNot Nothing Then Filter = "产品 = '" & .Value & "'" End IfEnd WithWith e.Form.Controls("cmbCustomer") If .Value IsNot Nothing Then If Filter > "" Then Filter = Filter & " or " End If Filter = Filter & "客户 = '" & .Value & "'" End IfEnd With