Dlookup, selecting with variable

[cihan]

Hello,



Could anyone help me what is wrong with the following code?

UNITCAPLOAD = DLookup("[UNITCAPLOAD]", "CSETTINGS", "[TYPEPRODUCT] = "& TYPEPRODUCT &" ")

It says me syntax error due to missing operator in TYPEPRODUCT.
TYPEPRODUCT is a string and is found correctly.

I appreciate your help.

[aytee111]

Strings need to be surrounded by quotes:
"[TYPEPRODUCT]='" & TYPEPRODUCT & "'") - those are single quotes within the double quotes

[cihan]

How about this one, the criteria is extended with AND statements
PCURRENT

UNITCAPLOAD = DLookup("[UNITCAPLOAD]", "CSETTINGS", "[TYPEPRODUCT] = '" & TYPEPRODUCT & "' AND [PCURRENT] = '" & PCURRENT & "' AND [Kv] = '" & Kv & "' AND [CONTACT] = '" & CONTACT & "'")

[aytee111]

Is there something wrong with this? It looks ok, as long as all the fields referenced are strings. Remove the single quotes for numeric.

[cihan]

I tried this as only TYPEPRODUCT is a string and other parameters are type double
UNITCAPLOAD = DLookup("[UNITCAPLOAD]", "CSETTINGS", "[TYPEPRODUCT] = '" & TYPEPRODUCT & "' AND [PCURRENT] = " & PCURRENT & " AND [Kv] = " & Kv & " AND [CONTACT] = " & CONTACT & "")

Here you see the error message
error1.jpg

[cihan]

See error message:
Runtime error '3075'
Syntax error (comma) in query expression '[TYPEPRODUCT]='3DN1' AND [PCURRENT]= 1250 AND [Kv]= 72,5 AND [CONTACT]= 2'.

[aytee111]

1 - there must be double quotes surrounding the whole string - "[TYPEPRODUCT....=2"
2 - you are using a comma instead of a dot as a decimal point? Is this the settings on your computer? I'm not sure how Access handles this.
3 - in your other example - [CONTACT] = " & CONTACT & "") - you don't need the last bit: [CONTACT] = " & CONTACT) - although it doesn't seem to have made any difference