Dear all,
a simply simply question...that is taking me hours!
This is the SQL sentence from a Query in a combo (which is filtered for another combo, nothing special, letting only the values with the first letter in that combo). How can I write it for VBA???? (Please, indicate all the ", I usually make a big mesh with it )
SELECT TABLE.IDName, TABLE.Surname
FROM TABLE
WHERE (((TABLE.Surname) Like [Forms]![Nameform]![Combo14] & "*"))
ORDER BY TABLE.Surname;
The problem is in the bold text; I think)
Among all the attempts I tried, this is one of them:
"SELECT TABLE.IDName, TABLE.Surname FROM TABLE" & _
"WHERE TABLE.Surname= " & Me.Combo14.Value & "*" _
"ORDER BY TABLE.Surname" & ";"
Thank you very much in advance.
Rafa
a simply simply question...that is taking me hours!
This is the SQL sentence from a Query in a combo (which is filtered for another combo, nothing special, letting only the values with the first letter in that combo). How can I write it for VBA???? (Please, indicate all the ", I usually make a big mesh with it )
SELECT TABLE.IDName, TABLE.Surname
FROM TABLE
WHERE (((TABLE.Surname) Like [Forms]![Nameform]![Combo14] & "*"))
ORDER BY TABLE.Surname;
The problem is in the bold text; I think)
Among all the attempts I tried, this is one of them:
"SELECT TABLE.IDName, TABLE.Surname FROM TABLE" & _
"WHERE TABLE.Surname= " & Me.Combo14.Value & "*" _
"ORDER BY TABLE.Surname" & ";"
Thank you very much in advance.
Rafa