auto fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
Chris said:
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.
Click to expand...


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.
 
Back
Top