sort listbox without getting focus.

  • Thread starter Thread starter dimitrij
  • Start date Start date
D

dimitrij

hi all
how do i sort the listbox entries without getting focus on?
I am searching this function and googled through the internet not
finding an answer ;-)

my objects: form, listbox and command
access 2003 windows xp

code:

List.AddItem ("2005.11.1")
List.AddItem ("2006.2.1")
List.AddItem ("2007.11.2")
List.AddItem ("2005.11.1")
 
Dear Dimitrij:

Does this list box have other rows, perhaps with a query source?

If so, use a UNION in your query to add your "constant" rows and sort that
in the query. That should fix it.

Tom Ellison
 
Back
Top