Dlookup Error

[PicoTTS]

I have a table called "Customers" that has the fieldsnames of "Names", "Address", and City"

I've created a query from another table. One of the fields in this table is a lookup field called "Customer" that lists the "Names" from the Customers Table.

I am trying to add another query field using the following to get the address of the customer in question:



CustomerAddress: DLookUp("[Address]","[Customers]","[Names] = " & Customer)

When I run the query, I get a #error. I have double checked to make sure all the field names are correct.

[PicoTTS]

I have figured it out.
I have to use:
CustomerAddress: DLookUp("[Address]","[Customers]","[Names] = '" & [Customer] & "'")