Sort for Value List or Combo Box

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a form that selects customer records from a table
of 20,000 names. Currently I use a combo box to select the
customer record. The problem is, if the user types in
letters that doesn't match any actual records, the results
for the combo box are blank, necessitating the user to
start over. Combine 20,000 customer records and 8 year old
computers and this is a slow process. Is there a way to
move to a part of the alphabet in a value list or combo
box without filtering out unmatching names?

Thank you.
 
Back
Top