auto fill

[Guest]

I have a table containing two columns, "part number" and "description". I
would like to make a form with a combo box contianing the part number and I
would like it to auto fill the description. Can someone help??

 

[Marshall Barton]

I have a table containing two columns, "part number" and "description". I
would like to make a form with a combo box contianing the part number and I
would like it to auto fill the description.

Change the combo box's RowSource query to retrieve both
columns.

SELECT partnum, descr
FROM thetable
ORDER BY partnum

If you don't want to see the description in the dropdown
list, set it's corresponding ColumnWidth to 0.

Then the text box can just use the expression
=combobox.Column(1)
to display the selected part's description.