all, using access 2013. I am trying to use a dlookup:
I am getting: #errorCode:=DLookUp("[Cost]","tblpricing","[cust_id] = " & [sfrmApprdPrice].[Form]![cust_id])
I checked all my spelling and the fields both on the form and in the table and I can't figure out why I'm getting this error.
I am using a similar dlookup on the same form and it works:=Can anyone help me please. ThanksCode:DLookUp("[SS]","tblScale","[FTE] = " & [sfrmApprdPrice].[Form]![FTE])