Hello. The Dlookup below works but does not seem to distinguish between the (1,4,5) [tblSubject_SubjectCode] criteria. Do I have the syntax right for this?
I am looking for any of the three - it could be literally a 1 or 4 or 5 in that field.
Any help with this would be appreciated ...
=Nz(DLookUp("[DocNumber]","tblDocuments","[tblClients_fldDRCClientID]=" & [Forms]![frmScreen_SubformTestingPB]![MeFKID] & " And [RelatedDebtAcctNo] = [Forms]![frmScreen_SubformTestingPB]![txtAcctNumber]" & " And [tblSubject_SubjectCode] In (1,4,5)"),0)
I am looking for any of the three - it could be literally a 1 or 4 or 5 in that field.
Any help with this would be appreciated ...
=Nz(DLookUp("[DocNumber]","tblDocuments","[tblClients_fldDRCClientID]=" & [Forms]![frmScreen_SubformTestingPB]![MeFKID] & " And [RelatedDebtAcctNo] = [Forms]![frmScreen_SubformTestingPB]![txtAcctNumber]" & " And [tblSubject_SubjectCode] In (1,4,5)"),0)