How do I join a querry field to a table in a form's SQL

[Bob H]

From another post, where I have recieved some help, I am now wanting a
little more.
I am told that 'In the main Shipping_Control form source SQL you have to
join the qryPartValue to tblShipping_Control.'


This is the SQL from the qryPartValues
SELECT Shipping_Control.DescriptionOfCargo, Shipping_Control.CargoQty,
tblValues.Value, ([Shipping_Control].[CargoQty]*[tblValues].[Value]) AS
CommercialValue, Shipping_Control.ShippingDate, Shipping_Control.ShipTo,
Shipping_Control.ShipFrom, Shipping_Control.CollectionNoteNo,
Shipping_Control.PackingListNo, Shipping_Control.ShipmentID,
Shipping_Control.Customer
FROM Shipping_Control INNER JOIN tblValues ON
Shipping_Control.[DescriptionOfCargo] = tblValues.[HGGPPart]
WHERE ((Not (Shipping_Control.Customer)="GDF SUEZ"))
ORDER BY Shipping_Control.DescriptionOfCargo;

The main table has a large number of fields, and the one I want
populated is the commercialvalue field in the main Shipping_Control form
which would be the calculated value from the qryPartValues.

Thanks