把你的控件名称写正确
Dim Filter As StringWith e.Form.Controls("textbox1") If .Value IsNot Nothing Then Filter = "销售类别 = '" & .Value & "'" End IfEnd WithIf Filter > "" Then Tables("合同订单评审与生产通知单_table3").Filter = FilterEnd If