Sorting Ascended

[Dalagrath]

Okay, I like you guyss because you bring me knowledge, so time for some more!



In a form I have (frmDiceRoll) I hit a button and some numbers are plopped into unbound text boxes using a Random 1-20 number. Now, my question is simple:

Is there a way to have all of this numbers sorted by highest to lowest AND can I have the label of that number be listed next to it on the same form?

[ssanfu]

Instead of plopping the numbers into unbound text boxes, cram them into an array. Do a bubble sort or quick sort, then push the sorted numbers into the unbound text boxes. Since you know the text box names, you should know the label names. Do a number to word conversion and shove the text of the number into the label.

Here is one example of converting numbers to words:

http://www.mvps.org/access/modules/mdl0047.htm

[Dalagrath]

I don't think you understand what I am saying.

Button gives me 3 numbers in textfields. (e.g. 9,8,7)

Now, I need to know the simpliest way to sort them into a table/subform on the same form from most to least. After that, I want them to use a Dlookup or relationship to show the names that belong with those numbers.

[ssanfu]

OK, you press a button and 3 numbers are generated. Are they put into unbound text boxes? You an still write a sort routine to sort the numbers

I want them to use a Dlookup or relationship to show the names that belong with those numbers.

I don't understand what you mean by "names that belong with those numbers".


Would you post the code for the button?
Would you provide an example of the numbers and the names?