Select From Inner Join error?

Hello,

What are we doing wrong
i can't get it working :(

Code:

---

Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim qry As String, i As Integer

qry = "SELECT TBL_ImportList.m_Referentie " & _
        "FROM TBL_List INNER JOIN TBL_ImportList " & _
        "ON TBL_List.ID = TBL_ImportList.ID " & _
        "WHERE TBL_List.m_Customer_Name LIKE '%" & Me.txtfirstname.value & "%'"

cnn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ThisWorkbook.Path & "\Database.ACCDB"
rst.Open qry, cnn, adOpenKeyset, adLockOptimistic

---

error image here

-ThanksAttachment 25830

The most obvious thing is that the "Like" syntax normally uses the asterix "*" and not "%".
The other normal thing with Access queries is that you do not need to specify .value when referring to a form field.
An error description would be better than an error number.
Have you tried creating this as an actual query first?
As I have a program that will convert it in to VBA code.

Hello

the error message says:
Values for one or more required parameters are missing.

Quote:

---

Have you tried creating this as an actual query first?

---

no because i have no idea how to do that :(

Okay i think i found it

Code:

---

  qry = "SELECT TBL_ImportList.m_Referentie FROM TBL_ImportList INNER JOIN TBL_List ON TBL_List.ID = TBL_ImportList.ID WHERE TBL_ImportList.m_Customer_Name = '" & txtfirstname.value & "'"

---

works now

thanks

-Tim

Quote:

---

Originally Posted by OBP

The most obvious thing is that the "Like" syntax normally uses the asterix "*" and not "%".

---

Not in SQL it's not.

Thank you for your input.