Solved Dlookup multiple criteria (1 Viewer)

AnilBagga

Member
Local time
Today, 19:03
Joined
Apr 9, 2020
Messages
223
I have seen multiple posts on these and seem to be making a stupid error in logic/syntax which I cannot pinpoint

The expression I built is as below.

=DLookUp("[FGSpecs]","CustSODtlsTbl","[ERPfgcode]= '" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[ItemCode] & "'"
and "[HeaderID]=" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[SOHdrID])

Expression 1 works well but when I concatenate the second expression it gives the first record value of FGSpecs in the table

I also tried this

=DLookUp("[FGSpecs]","CustSODtlsTbl","[ERPfgcode]= '" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[ItemCode] & "'
and [HeaderID]=" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[SOHdrID]") but get a syntax error
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 21:33
Joined
May 7, 2009
Messages
19,175
=DLookUp("[FGSpecs]","CustSODtlsTbl","[ERPfgcode]= '" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[ItemCode] & "' and [HeaderID]=" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[SOHdrID])
 

AnilBagga

Member
Local time
Today, 19:03
Joined
Apr 9, 2020
Messages
223
=DLookUp("[FGSpecs]","CustSODtlsTbl","[ERPfgcode]= '" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[ItemCode] & "' and [HeaderID]=" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[SOHdrID])
Thank you Arnel. I understood the mistake I was making
 

Gasman

Enthusiastic Amateur
Local time
Today, 13:33
Joined
Sep 21, 2011
Messages
14,052
Put the criteria into a string variable an debug.print it.
That will show your errors.
When you get it right, use in the domain function.
 

Users who are viewing this thread

Top Bottom