Howto make combobox selections appear in ascending order

[MsLady]

Hello friends,
Please can anyone tell me how i can make the selections in my combo box (combo is bound to column1 of a table) appear in ascending order, by name (column2).
I.e. It's bound by column 1 (with is the Id#), but i want it to appear in ascending by column 2 (Usernames) to make selections easier. Please help

 

[Smart]

I would create a query that selects the the Id and usernames from your table and sort it on the usernames field

use this query as the row source of your combo box

 

[MsLady]

Okay. Thanks Smart, i'll give it a try