Solved Dlookup multiple criteria

[AnilBagga]

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]

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

 

[AnilBagga]

=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]

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.