how to make connection between cells in Access form

[monaparnian]

Hi,

I've designed below form and I've used lookup for Product code and production description.
both these information is available in one table.
is there any option in access that when I choose product code, production description comes to the form automatically.

below is a part of my form:


I hope someone can help me and tell me how i can do it.

Thanks,
Mona

 

[pbaldy]

A couple of ways:

http://www.baldyweb.com/Autofill.htm