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 & "'")