主题：[求助]关于两个条件的模糊查询

With e.Form.Controls("cmbcustomer1")
    If .text IsNot Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If

        Filter = Filter & "单位名称 like '%" & .text & "%'"
    End If
End With
With e.Form.Controls("cmbproduct1")
    If .text <> Nothing Then
        If Filter > "" Then
            Filter = Filter & " And "
        End If
        Filter = Filter & "模版编号 like '%" & .text & "%'"
    End If
End With

如果一个模糊条件的查询没有问题，但如果这样两个条件的模糊查询，会出现如下错误