xveganx007
Registered User.
- Local time
- Today, 18:16
- Joined
- Apr 4, 2000
- Messages
- 10
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
strAudit = [AUDIT_NO]
strIndex = [INDXITMNO]
str1 = DLookup("[APGNO]", "QASALPRA", "[AUDIT_NO] = " & strAudit & "[INDXITMNO] = " & strIndex)
how do i fix this?
thanks matt