Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("标准清单_Table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "'%" & txt & "%'"
tbl.Filter = "序号 Like " & txt
End If
Dim txt1 As String = e.Form.Controls("TextBox2").Text
Dim tbl1 As Table = Tables("标准清单_Table1")
If txt1 = "" Then
tbl1.Filter = ""
Else
txt1 = "'%" & txt & "%'"
tbl1.Filter = tbl.Filter & "标号 Like " & txt
End If
筛选不出来
错误信息为:语法错误:“标号”运算符后缺少操作数。(两个TextBox中都输入数据)
语法错误:“Like”运算符后缺少操作数。(只输入标号的TextBox)
如果只输入序号的Textbox,则表无反应。
跪求大神解决,谢谢!