有点甜老师,又要麻烦你,我想建立一个textbox控件,查询符合两列的内容,一列的列名是yxdc,另一列是xkjs,如果是同时符合两列内容,代码是怎样的,如果是只要符合若一列内容又是怎么写代码。这是你以前给我的代码
With e.Form.Controls("textbox8")
If .Value IsNot Nothing Then
Filter &= " and yxdc like '%" & .Value & "%'"
End If
End With
With e.Form.Controls("textbox6")
If .Value IsNot Nothing Then
Dim str As String = ""
For Each s As String In .value.split(" ")
str &= "yxdc like '%" & s & "%' or "
Next
Filter &= " and (" & str.substring(0, str.length-4) & ")"
End If
End With
在这基础上,要完成以上两个要求的的查询,代码怎么改啊,多帮忙啊辛苦啦谢谢!
[此贴子已经被作者于2018/12/22 10:50:12编辑过]