Dim Filter As String = "1=1" With e.Form.Controls("姓名3") If .Value IsNot Nothing Then Filter = Filter & " and 姓名 = '" & .Value & "'" End If End With With e.Form.Controls("工作日期3") If .Value IsNot Nothing Then Filter = Filter & " and 工作日期 = #" & .Value & "#" End If End With