Loading a lookup field into a form

[KGL]

I am designing a Customer Order form. The form has a combo box that is a lookup on a Product table. The Product table contains 2 fields: Name and Price (apart from the primary key). When I select a product from the combo box I want another field on the form to show its Price. Can anyone help.

Thanks.

I am a programmer and database designer but new to Access.