combobox - controlling appearance of drop-down list

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
 
K

Kevin

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup current record with ComboBox, any changes create new record 3
Combobox Sected Item 3
How to select the first combobox item (ie. Set Combobox.ListIndex = 0) 2
Access combobox does not display all decimal digits if end on zero 5
Can't select option in combobox 0
Change rowsource on combobox in OnEnter event 6
Filtered drop down list 2
Wrong Data Type Error for Selected Value of a ComboBox 5

Top