sql syntax parameter

[matrixknow]

Hallo,

If I type the parameter for the where condition hard coded, it works.

& "WHERE ((([Tbl_HR Contacts].HRC_C)= ""C002""));"

Because there are a number of parameters I get this by a recordset and a string. He does not give an error but he give back 0 records, it should be for C002 = 5
I looked at the value of strCode with a message box.

Dim strCode As String
   strCode = rst!HRC


& "WHERE ((([Tbl_HR Contacts].HRC)= " & strCode & "));"

 

[LarrySteele]

You need to wrap your string with quotes (single works for inner quotes):

[tt]"WHERE ((([Tbl_HR Contacts].HRC)= '" & strCode & "'));"[/tt]

HTH,
Larry

 

[matrixknow]

& "WHERE ((([Tbl_HR Contacts].HRC_C)='" & rst!HRC_C & "'));"

found !

 

[matrixknow]

thanks Larry,

I came to the same conclusion. I put my SQL in a msgbox and saw what he was writing. I took me a while .... dammed syntax