Aloha...
I'm not a programmer, but I wonder if you could add a column to the combo box which would contain numeric values, ie 1, 2, 3, ..., with the matching column being the Activity Type listed in order of priority. Then it seems that you could tell the query to sort on the numeric column...