Loading a lookup field into a form

K

KGL

Joined
Jun 27, 2007
Messages
2
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculated field in a form 1
Lookup table data from Form 2
Form with a Lookup Table 1
single column lookup with multile column return 1
getting a value in a table based on combo box selection in form 3
Lookup field returns wrong value 6
Combo Boxes/Queries 1
Access Form with Combo box 5

Top