窗口里有个输入项为操作者的名字
现在的代码是 Filter = Filter & "操作者 = '" & .Value & "'",结果是筛选条件为 :操作者=.Value
想问下怎么改使筛选出来的结果为 包含输入的操作者名字,谢谢!
Dim Filter As String
Filter = ""
With e.Form.Controls("操作者")
If .Value IsNot Nothing Then
If Filter >"" Then
Filter = Filter & " And "
End If
Filter = Filter & "操作者 = '" & .Value & "'"
End If
End With
此主题相关图片如下:qq截圖20140604173352.png
![dvubb 图片点击可在新窗口打开查看](UploadFile/2014-6/2014641734235089.png)
[此贴子已经被作者于2014-6-4 17:36:05编辑过]