dLookup Problems

  • Thread starter Thread starter Pepper
  • Start date Start date
P

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
 
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.
 
Back
Top