Getting two fields to link in a form

[EmCcausland]

I'm trying to make a form that will allow me to add a qty to a field in a table, but I have one field that is a part number and one field that is a description. Is there a way to make it so when you select the part number the field for the description changes to the correct description?

[CJ_London]

if the rowsource to your partnumber combo is something like

SELECT PartNum, PartDesc FROM tblPArts

and you have number of columns set to 2

change the description combo to a textbox and set its controlsource to

=partnumbercombo.column(1)