Dlookup with with 2 fields as criteria (1 Viewer)

[xveganx007]

i am trying to get the apgno stored in my variable str1 using the values from the feilds AUDIT_NO & INDXITMNO. but i don't know the syntax for doing this. this is what i have so far:
strAudit = [AUDIT_NO]
strIndex = [INDXITMNO]
str1 = DLookup("[APGNO]", "QASALPRA", "[AUDIT_NO] = " & strAudit & "[INDXITMNO] = " & strIndex)

how do i fix this?
thanks matt

 

[xveganx007]

Thanks Pat, that did the trick!