Sort Combo Box Contents

[aputt@ssd.com]

I have a ComboBox list 2 columns. One column is an ID number and the second column is a persons name. I have the column headings displayed. Is it possible to have the combo box sort on either column by just clicking on the column heading?

[RuralGuy]

The RowSource of the ComboBox would need to change each time.

[aputt@ssd.com]

I attempted to perform the sorting on the combo (Using On Click) by using an if statement and changing the Row Source to whichever query is needed. I get nothing for my efforts. Can you provide a sample for me to follow? I am using Access 2003.

[RuralGuy]

Now that I think about it, I do not know if you can see the column where the click happens. The control can return the Row selected but the columns are just for display.