Allowing the user to sort the list in a combo

[lizat]

Dear loungers,

I have a combo that shows a multi-column list, it is sorted by the first colum but under ceratin circumstances the user will find it more usefule to be sorted by column two. Is there a way of allowing the user to click the column header to sort the list?

Manay thanks.......................... liz

[WendellB]

Unfortunately the standard Access combo box doesn't provide the capability to do that sort of thing. One possible workaround would be to use a double-click in the combo box to change the Row Source of the combo to sort on the second column. That requires some VBA code of course.

[lizat]

Ah, so I'll dust down my vba, Thanks Wendell.................... liz