I understand what you're saying, as well as what @moke123 (below) is saying, and it's working so long as I have a list of no more than 9 items. It seems that when Access is reading anything over 9, it's following an improper sort (i.e. instead of going 1, 2, 4, 11, it's going 1, 11, 2, 4).
Am I doing something wrong? I've tried changing the bound column, deleting and re-working the tables, queries, etc. and nothing is working.
Here's my Lookup Criteria
Here's query criteria (tried deleting this query, as well, and have it read in from the file, but no luck):
And here are the differences between options when only 1-9 may be selected vs what happens when you have 10+ selected. Note that it *should* read "R, D, E, A" since that's the order I want to keep (note that the order displayed in the option boxes are in the proper order, but the returned value--what is displaying in the drop-down--is not.):