Sorting on the fly

A

Access101

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.
 
J

John Spencer

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
'====================================================
 
Top