dlookup error

[slimjen]

all, using access 2013. I am trying to use a dlookup:

=DLookUp("[Cost]","tblpricing","[cust_id] = " & [sfrmApprdPrice].[Form]![cust_id])

I am getting: #error
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:=

DLookUp("[SS]","tblScale","[FTE] = " & [sfrmApprdPrice].[Form]![FTE])

Can anyone help me please. Thanks

[pbaldy]

If the data type of cust_id is text, you'd need delimiters.

[slimjen]

cust_id is text. delimiters???

[slimjen]

Ok. I modified the code:

=DLookUp("[Cost]","tblpricing","[cust_id] =' " & [sfrmApprdPrice].[Form]![cust_id] & "'")

Now; I don't get anything and I know the field is not blank.

[Micron]

Is the Cust_Id a text value? Your reference to the form control doesn't look right if I've deciphered the design. More like Forms![Order Details]!ProductID

If you're doing this in code, debug.print the criteria result in the immediate window and see what you get (?[sfrmApprdPrice].[Form]![cust_id])

[pbaldy]

Take the space out from between the quotes.

[pbaldy]

This may be simpler and would be more efficient if appropriate:

http://www.baldyweb.com/Autofill.htm