Look up fields

  • Thread starter Thread starter TaylorLeigh
  • Start date Start date
T

TaylorLeigh

I have a field for products. We have several products from which to choose
and I am curious as to what method you would suggest to supply the
information for looking up products. Currently I have a drop down list but
needless to say you have to scroll several entries to see all the products
listed. We do not use product numbers and people who do data entry have to
see the list to know which one to select.

Thanks much
 
I have a field for products. We have several products from which to choose
and I am curious as to what method you would suggest to supply the
information for looking up products. Currently I have a drop down list but
needless to say you have to scroll several entries to see all the products
listed. We do not use product numbers and people who do data entry have to
see the list to know which one to select.

Thanks much
Click to expand...

Are your users aware that you can tab into a Combo Box on a form and type the
first letter or two of the product name, and the combo will jump directly to
that record? It's not necessary to scroll (though of course you can).
 
Ok! I'm down with that. How can I get a drop down list that will show
entries and will change the entries as I type in letters. Many of our
products start with the same letters/numbers. I would like to have a drop
down list that would let them choose from 4 or 5 and the 4 or 5 would change
as you type more letters. As soon as they see what they want they can
highlight that field and choose it.

Thanks,
 
Back
Top