Sort a continuous form using an unbound column of a combobox

[pmulconry]

Hi All,

I am using Access 2003. I have a continuous form and would like to sort the records based on an unbound column of a combobox. I can sort the form based on the bound column, just can't figure out how to do it on the unbound column. I would like to be able to do this, if possible, without adding extra controls on the form.

I have tried playing around with myCombobox.Column(0) but with no luck.

Any assistance would be great.

Cheers
Paddy