Jose,
Make your combo a 2 column combo, with the associated ProductName
in the second column. (ex. cboProductCode)
NoOfCols = 2
ColWidths = 1"; 1" (or whatever)
Place an unbound text control on your form, with a Control Source of...
= cboProductCode.Column(2)
(combo columns are numbered left to right 1, 2, 3, 4, etc...)
Whenever a ProductCode is selecetd in the combo, the text control will
"display" the associated ProductName.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Jose Lopes" wrote in message
...
This is quite simple I know, but I only get my hands on Access whenever I
need it so I'm always forgetting simple tasks like this one. I even had
some
trouble choosing this question's title, can you imagine it? :/

I have two tables, ORDERS and PRODUCTS.

My ORDERS form has a combo box where I can pick the PRODUCT code from the
PRODUCTS table but I also want to see the PRODUCT_NAME (PRODUCTS table)
field
on this form in a different box.

Thx in advance.