Can I sort a listbox?

[Nirious]

Ordo I have to write the sorting code myself? Or is there someone who already did it

 

[namliam]

In the rowsource simply add Order by to the sql...

Regardz

 

[Nirious]

But it isn't based on a tabelcolumn. It contains values that I added myself.

 

[namliam]

If you typed the values yourself your stuck with the order you typed them in.
If however you transfer them to a table its easy.

I usually have a table for boxes like that to which i add a name column (hiden to the user offcourse) then query that table (order by etc included ) for the values i need for that specific combo box.
If then ever anything changes (need a new value or i made a typo or something) I simply add/delete/update the table and presto changed thru the whole app.

Regardz & GL

 

[Nirious]

OK, thx. I'll give that a try

Nirious