DLOOKUP with multiple criteria

[UT227]

I tried to look at previous postings, but I couldn't figure it out. I have some text boxes that I'm trying to get data from a query. I need [RaceID] = 1 and [ContactDisp] = 3. This is what I'm trying to use, but get an error:
=DLookUp("[TotalDisp]","qryStatDispo3a","[RaceID] =" & 1 & "AND [ContactDisp] ='" & 3 & "'")

[Minty]

If those are fixed values the no need for all the concatenation.

=DLookUp("[TotalDisp]","qryStatDispo3a","[RaceID] =1 AND [ContactDisp] ='3'")

That also assumes ContactDisplay is Text?

[June7]

Just need a space in front of AND. But don't need concatenation with static parameters.

=DLookUp("[TotalDisp]","qryStatDispo3a","[RaceID] = 1 AND [ContactDisp] = '3'")

ContactDisp is a text data type? If it's a number, remove apostrophe delimiters.

[UT227]

RaceID and ContactDisp are both coming from the query.

[UT227]

RaceID is a number. ContactDisp is calculated by the query.

[UT227]

I must be tired. I was using the wrong field.
=DLookUp("TotalDisp","qryStatDispo3a","RaceID = 1 and ContactDispositionID = 3")

This worked.

[Welshgasman]

For when you do actually need to concatenate.

I tend to put the criteria into a string variable for domain functions if not a single simple criteria.
Then I can debug.print them to see if I have the syntax correct.
Then when correct, I can use that in the function.
Plus, if you cannot see the error, you can copy and paste here or eslewhere, so someone can point out the error.?

[UT227]

I appreciate the help. Thank you.