主题：模糊查询报错

Dim txt As String = e.Form.Controls("TextBox1").Text
Dim tbl As Table = Tables("综合查询_tblWaiqinanpai")
If txt = "" Then
    tbl.Filter = ""
Else
    txt = "'*" & txt & "*'"
    tbl.Filter = "Works_title Like " & txt & " Or Works_content Like " & txt
End If

Dim tbl2 As Table = Tables("综合查询_tblKehugenjin")
If txt = "" Then
    tbl2.Filter = ""
Else
    txt = "'*" & txt & "*'"
    tbl2.Filter = "track_note Like " & txt & " Or 意向名称 Like " & txt
End If

 

2个TABLE一起模糊查询就报错误“无法在 System.String 和 System.Int32 上执行“*”操作。

如果单独使用TABLE做模糊查询哪个都没问题，这个是怎么解决呀

don输入字符串提示

语法错误:“'*输入的字符串*'”运算符后缺少操作数。

已经找到原因了，谢谢DON,我重复赋值了