#Error message

[atadbitslow]

I'm baffled....

Why does this expression give me an #error in my query,

Expr2: DLookUp("descrip","cash descriptions","FUNDCODE=" & [cashnycashitemsdetail]![FundCode])

and this expression does not??

Expr1: DLookUp("cashid","cash items","giftid=" & [cashnycashitemsdetail]![giftid])

I basically copied and pasted the expression that works, and just changed the table and fields.....?

Thanks!

 

[ryanku]

If the field FUNDCODE has Text data type, you have to change that expression, from:

DLookUp("descrip","cash descriptions","FUNDCODE=" & [cashnycashitemsdetail]![FundCode])

become:

DLookUp("descrip","cash descriptions","FUNDCODE='" & [cashnycashitemsdetail]![FundCode] & "'&quot