Concatenating strings in DLOOKUP and elsewhere

[colezpapa]

I was having trouble with a DLOOKUP getting it to work correctly with a string value. I had the code...
x=DLookup("field", "table", "field = ' " & strValue & " ' ")

and I was getting an error...what worked was
"field = """ & strValue & """")

It's not clear to why this is so.
Also, I read in Allen Browne's tips that the single quote character is not the recommended approach: because it fails as soon as a name contains an apostrophe...

 

[PHV]

x = DLookup("field", "table", "field='" & Replace(strValue, "'", "''") & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886