老师们代码如下:
Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("窗口1_Table1")
If txt = "" Then
tbl.Filter = ""
Else
txt = "'%" & txt.replace("*","[*]").replace("%","[%]").replace("'","''") & "%'"
tbl.Filter = "识别码 Like " & txt & " Or 分类 Like " & txt & " Or 名称 Like " & txt & " Or 规格 Like " & txt & " Or 用途 Like " & txt & " Or 备注 Like " & txt & "and 库存数量>'0'"
End If
条件"and 库存数量>'0'"不执行是什么道理呢? 这个应该怎么写?