Combo Boxes

[Guest]

I am building a form with Access 2003. My associated table has two columns,
part number and part description. Is there a way that I can enter a part
number in a box and have the associated part description pop up in another
box? I have a combo box and when I use the down arrow I can see both the
part number column and the part description column, but the part number is
the only thing that comes up in the box. I know I can get them both to come
up if I combine them within the same field, but I was hoping there was a way
to do it without doing that, either with a query or maybe writing code. If I
can do it with code, can someone please walk me through it.

Thank you

 

[Guest]

In the afterupdate event of the combo use

[textbox2] = [combobox].column(n)

where "n" is the column number for the description (zero is the first
column) and obviously change "textbox2" and [combobox] as appropriate