Returning value from related table

[Mick]

Access 03
Have four entities. Customer, Order, Order Details and Product.

In an order form (based on Order as parent and OrderDetails as
SubForm) I want to return the price of an item stored in the products
table.

I have tried to build a query and use the value from the ProductID
field as the criteria and place the looked up PartPrice in the control
source of the ProductPrice field but get a #name error.

This works fine on a standalone form, don't understand why it won't
work on a subform.

Any help appreciated.

Thanks

Mick

 

[KARL DEWEY]

Do not use criteria as you would need to refresh everytime you changed records.
Use a join in you query.