Sorting on the fly

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

Guest

During Form Open, I'm filling a combo box with a list of file names from a
directory: tmp = Dir("*.txt"), RowSource, etc.

What's the best way to sort ASC/DESC this list as it comes in, so they're
all sorted correctly in the drop down. Or do I have to store data in a tmp
table, and then sort adn base combo list of items in this sorted table?

Any help is appreciated.
 
You could bring all the items into an array, sort the array, and then
use the values in the sorted array to populate the drop down.

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================
 

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

Dynamic sorting of listbox based on crosstab 2
Programmatically change combo box sorting 4
Manually sorting a GridView 1
SQL Query ORDER BY Sort Order (Variable) 3
Sort query returns no records 1
Sorting of table depending on a drop-down-list entry 4
Sort fields on continous form. 1
Sort fields with 1.1-1, 1.1-10a, etc. 9

Back
Top