Dim Filter As String
With e.Form.Controls("TextBox1") If .Value IsNot Nothing Then Filter = "产品编号= '" & .Value & "'" End IfEnd With