Combo Box

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

Guest

Please Help!

I have a combo box that shows both a Barcode and Product Description, the
Barcode is tied into the combo box. When a sales associate goes to do a sale
they type in the barcode/ or scan and the product appears - it works great.
The only problem being that when they don't know the barcode - it become
really difficult to find the product by description. Is there anyway that a
quick search could be incorporated?

Thanks
 
Sar,

It's not necessary to display the Barcode in the combo box, and yet still
store it in the table when selected. What is stored is controlled by the
Bound Column property, and what is displayed by the Column Widths property,
which lists each column and the width in inches to allocate to their display.

If you set the Barcode width to 0", and add an "Order By" clause to the
combo box' Row Source property SQL statement, the descriptions will be
displayed in alphabetical order, and the sales associate can search by
description efficiently.

SELECT Barcode, Description from Products ORDER BY Description;

HTH
Sprinks
 
Back
Top