Dim Filter As String With e.Form.Controls("日期") If .Value IsNot Nothing Then Filter = "日期 = #" & .Value & "#" End If End With With e.Form.Controls("班组") If .Value IsNot Nothing Then If Filter > "" Then Filter = Filter & " And " End If Filter = Filter & "班组 = '" & .Value & "'" End If End With If Filter > "" Then Tables("表A").Filter = Filter End If