Need some DLookup Help For Customer

[burrina]

My table is Named Customers and the control source is TaxRate


I have an unbound textbox on my form (Text122) that I need for this value to show up in.

[June7]

What criteria determines the correct TaxRate? What are field names? What have you tried?

[burrina]

Each Customer has their own Tax Rate. Field name for TaxRate is TaxRate. I have tried using

DLookup("TaxRate", "Customers", "CustomerID = " & Forms![OrderDetails]!CustomerID)
I get #Name? as the field criteria.
The criteria is linked to each Customer by the primary key which is CustomerID
I want to lookup the TaxRate form the Customers table when a Customer is chosen on my OrderDetails form it will show THAT customers TaxRate.

[burrina]

Thanks, I finally got it. Had to change my Combo Lookup and then do a Column(2) thing.