Dim Filter As String = "1=1"With e.Form.Controls("姓名") If .Value IsNot Nothing Then Filter = Filter &" And 姓名= '" & .Value & "'" End IfEnd With
Filter = Filter & " and 已付款 = " & e.Form.Controls("已付款").Checked
Tables("明细").Filter = Filter