Dim Filter As StringWith e.Form.Controls("xx2") If .Value IsNot Nothing Then Filter = "学校名称= '" & .Value & "'" End IfEnd With
If Filter > "" Then e.Form.Controls("Table1").Table.Filter = FilterEnd If