Where in your Tables is this information stored?

I'd suggest having a Parts table with fields PartNumber and
ProductDescription (and perhaps other fields). On your Form, put a
Combo Box based on this table, bound to the PartNumber field in the
form's table. The combo's RowSource should be a query selecting the
part number and the description.

Put a Textbox on the form with a controlsource

=comboboxname.Column(1)

using your actual combo box's name; the (1) means display the *second*
column of the combo's row source query, it's zero based.

                 John W. Vinson[MVP]    

I also need to do the same in a table, will the same method work.
Thanks Heaps