DLookup Syntax Help

[Steven19]

I'm getting an error with the below DLookup.



What am I doing wrong?

DLookup("RiskLevelID","tblRiskAssessment","[ProductRiskID]='"& Me.boxDealSummary & "' AND [TransportRiskID]='" & Me.boxTransportSummary & "' AND [TransportArrangementsID]='" & Me.boxTransporting"'")

[Welshgasman]

You do not say what the error is?

I normally associate an ID as numeric?
Put the criteria into a string variable and Debug.Print that to show what you have, not what you think you have.

Basics.
Strings need single quotes surrounding them (unless it has a single quote in it)
Dates need # surrounding them and in mm/dd/yyyy or yyyymmdd format
Numerics need no surrounding characters.

[Steven19]

Expected = Is the error I am getting.

Each of the criteria are all numeric.

Regards

[Welshgasman]

Expected = Is the error I am getting.

Each of the criteria are all numeric.

Regards

So NO single quotes then?

I *thought* you were just showing the DLookUp code?
You need to assign the returned value to something?

lngRiskID = DlookUp( ......

[Micron]

Are you attempting to test this from the immediate window? Then you need to begin with question mark or you will get that error from there also.
?DLookup...

Otherwise, you need to assign the result to something as WGM says.

[davegri]

Also, at the end:

& Me.boxTransporting & "'")

[Steven19]

Thank you for all your hints and tips, I managed to get it working. So I had two issues.
1. I didn't assign the DLookUP to something, so thank you WGM
2. I did not ampersand, thank you Davegri