Originally Posted by
mmpboca
I've also tried to use the DLOOKUP that sets [txtEstNoUp] but can't get that to work at all as I get a syntax error. The code I tried for that is as follows: =DLookUp("[tblGenNoofCuts]![fldCutswBleed]","[tblGenNoofCuts]","[tblGenNoofCuts]![fldNoUp]=DLookUp("[tblPCFlatSize]![fldEstNoUp]","[tblPCFlatSize]","[tblPCFlatSize]![fldFlatSize]=""" & [Form]![cboFlatSize] & """")"). I'm thinking this second method just isn't a valid approach.
And for this, is "[cboFlatSize]" numeric or text?
If text, you might try
Code:
=DLookUp("[fldCutswBleed]","[tblGenNoofCuts]","[fldNoUp]= " & DLookUp("[fldEstNoUp]","[tblPCFlatSize]","[fldFlatSize]=""" & Me.[cboFlatSize] & """") )
If numeric, try:
Code:
=DLookUp("[fldCutswBleed]","[tblGenNoofCuts]","[fldNoUp]= " & DLookUp("[fldEstNoUp]","[tblPCFlatSize]","[fldFlatSize]=" & Me.[cboFlatSize]))