With e.Form If e.sender.text <> "输入型号/土号查询" Then Dim txt As String = e.Form.Controls("a").Text If txt = "" Then Tables("表A").Filter = "" Else txt = "'*" & txt & "*'" Tables("表A").Filter = "型号 Like " & txt & " Or 土号 Like " & txt End If End If End With