dLookup Problems

[Pepper]

I havbe a form and I need a textbox to reflect a sales
rep's name based on the account ID.

I tried putting this in the "default value" field:

=DLookUp("[Sales_rep]","Accounts","[Account_ID] =
Customer_ID ")

in return I get the #Name? error in the field.

The form field is called "customer_ID" and the Accounts
table key is called Account_ID

 

[Pepper]

Doh!

When I set the control value to that dlookup it worked.
You can kick a problem around for hours, but you'll never
figure out the answer until you actually post it.