combobox - controlling appearance of drop-down list

  • Thread starter Thread starter Sophie
  • Start date Start date
S

Sophie

hi
I have a combobox that lists works of art by ID number (a number between 001
and 999) and name. About 710 entries are listed. The RowSource is:

SELECT qryArt.ArtID, qryArt.ArtName FROM qryArt ORDER BY ArtID;

The combobox's AfterUpdate event has code to display the desired data. This
works perfectly.

When users are researching works of art, they typically view many ArtID's
that are close in value (eg 587, 589, 594...) But, every time they use the
combobox, it opens at the beginning of the list, so the user has to scroll
down a lot.

How can I get the combobox to open with the data in ascending order but
showing the LAST SELECTED choice at the top of the displayed list?

Hope this is clear.
Thanks
 
Set the Auto Expand = Yes in data property tab of combo box. I just want to
no for curiosity that why you need combo box for 700 entries, you may use a
text search facility and enhance the user experience. Let me know if you need
help with it!
 
Back
Top