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