adoqueryedit.RecordSource = "select * from frmsg where frname = '" & Text1.Text & " & Combo1.Text & " & "Combo12.Text & " '"

我用的Adodc控件和DataGrid控件

但报错了，是不是我的查询语句有问题

adoqueryedit.RecordSource = "select * from frmsg where FrName5 like + '%'+'" + Text1.Text + "'+'%'"

我现在做的模糊查询，如何也做成多重查询

我这样写了：
    adoqueryedit.RecordSource = "select * from frmsg where like + '%'+ ' " + Text1.Text + " '+ '%' + '%'+ ' " + Combo1.Text + " '+ '%' + '%'+ ' " + Combo2.Text + " '+ '%' + '%'+ ' " + Combo3.Text + " '+ '%' + '%'+ ' " + Text3.Text + " '+ '%' + '%'+ ' " + Text6.Text + " '+ '%' + '%'+ ' " + Text5.Text + " '+ '%'"

但它报“关键字like附近有语法错误

我做了个变量解决问题了
  Dim strsql As String
  
  strsql = ""
  If Trim(Text1.Text) <> "" Then
     strsql = "(FrName like '%" & Trim(Text1.Text) & "%')"
  End If
  If Trim(Combo1.Text) <> "" Then
     If strsql <> "" Then
        strsql = strsql & " and (TypeName like '%" & Trim(Combo1.Text) & "%')"
     Else
        strsql = "(TypeName like '%" & Trim(Combo1.Text) & "%')"
     End If
  End If