DLookup Question

[Nursery Ed]

I am trying to use the DLookup Function on a form. I want to input the customer’s name from a combo box and have the correct customer number returned in an adjacent bound text control.

The form (an invoice) is based on the Sales table. The customer number is in my Customers table.

I think that Access help is telling me the syntax should be:


=DLookup(CustomerID,Customers[,CustomerID) but this isn’t working.

My goal is to eliminate as many “input errors” as possible. Can anyone help me out with this?

 

[doran_doran]

try this, i used dlookup all the time and following works

=DLookUp("([CustomerID])","tbl_Customer","[CustomerID] = '" & [CustomerID] & "'")

replace tbl_customer with your destination table name.

Good luck
dianna goldsberg