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

[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...

 

[Stuart McCall]

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

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.