Can't get Query to work in Text Box - Please help....

[Mike]

What I am trying to do is pull information from a Many ("PPQuotes" Table) to
One ("Build Locations" Table) relationship into my form.

My form is based off of a PPQuotes table which contains all of my quotes.
I have a [Location ID] field in the PPQuotes table that is linked to a
[Location ID] field in the "Build Location" Table.

I want to bring the value of the [ScrapPackFreight] from the [Build
Locations] Table into an unbound text box. I've tried this using a query but
unfortunately, I get the old "?Name" error.

One other note, I did try replacing [Build Location Box] with the Location
ID field from the PPQuotes Table and still didn't get it to work.

Thanks for any help!

(SELECT [Build Locations].ScrapPackFreight
FROM [Build Locations] INNER JOIN PPQuotes ON [Build Locations].[Location
ID] = PPQuotes.[Build Location]
WHERE (((Build Locations].[Location ID])=[Build Location Box])));