Dsplay lookup data in form

[Number Six]

This is going to sound really stupid but I urgently need to have one form, where people can enter a product code and the description automatically shows in another field.

I have two tables, one for the form and another with all product codes and descriptions.

Presumaby I would need to make a query, which i've tried and failed miserably.

it seems so simple when you read the access help but i've missed something fundamental.

HELP!

Thank you.

PS I should have said my boss expects to enter data in one field - the product code - and the description automatically and instantly pops up in another field on the same form before leaving that particular record.

 

[Rich]

Use a two column combo box, just display the second column

 

[Number Six]

Thanks yes that will do fine.

Thank you very much

 

[Pat Hartman]

The best solution is to base your form on a query that joins the two tables. Be sure to use a left join to the lookup table and to lock any fields displayed from that table to prevent accidental updating.