Get value from table baseing on form field

[darkcez]

Hi everyone.

I'm new in Access and I have to make only one project. I have a little problem with my access forms. I have few tables: customers,products, orders and OrdersDetails. I made form to adding orders. I have field where I can choose Customer and subform where I can add ordered products. I have there combobox where i choose given product, field for product price and field for quantity. So the problem is following: When i choose product, I want the price field will be filled with value from Product table (appropiate for chosen product).
Can somebody help me with this? I will be very appreciate.

P.S. Sorry for my bad English, I hope you'll understand what I mean.

[jo15765]

Let me make sure I am understanding you correctly. You want to be able to pull up a specific product let's say a 4x6 note card, and have it display the price of the 4x6 note card?

[darkcez]

Exactly!

[jo15765]

Does the same table contain products and product prices?