How to show query value in a form?

[puffdog]

I face some problem in showing a value in a field.


I have 4 table, a query and a from.
My query have a QoH that which will calculate my quantity.
Then i create a form for a table . the form have 2 field that content
PartNo and Qty.
Then i create a new field to show the QoH from my query but a error #Name? show it,so how can i show the QoH on that field?
Thanks for giving a help..

 

[namliam]

Build the form on the query not the table..