Sorting not available on text box with combobox column as recordsource

[AkAlan via AccessMonster.com]

I have a text box which uses a combo box column value as it's recordsource. A
user wants to be able to sort on the text box but it is unavailable because
of the recordsource. Is there some kind of workaround for this.