How to select a description in a combo box but return a ID value

  • Thread starter Thread starter Goldar
  • Start date Start date
G

Goldar

I want to give the user to look up (in a combo box) a product by either
product number -or- description. If I display direction, how can I force the
combo box to return the product ID for the selected description? I have an
option box that where the user selects either the product ID or the
description as the displayed information in the combo box.

Thanks...
 
Goldar said:
I want to give the user to look up (in a combo box) a product by either
product number -or- description. If I display direction, how can I force
the
combo box to return the product ID for the selected description? I have an
option box that where the user selects either the product ID or the
description as the displayed information in the combo box.

Thanks...
Click to expand...

Make a Query that includes ProductID and Description. Set this Query as the
combo's RowSource. Set the ColumnCount property to 2. Set the ColumnWidths
property to 0;1 (you may need to adjust this). Set the BoundColumn property
to 1.

That ought to do it.
 
Back
Top