Rank values in a text box

[echorley]

I use access to keep score during trivia games in my class. I have textboxes with spin buttons that updates the score. What I need is another text box above each of the previously named textboxes that rank each score. I could write a monster code that compared each text box to each other and then displayed their rank. I was wondering if there is a short cut in VB to compare multiple textbox values. Thanks.

 

[fpendino]

Try adding a rank field to your table and add it to your form, as I am assuming you are using a continous form. Each time one of the spin buttons is pressed, have it pull a recordset off of your table, ordered by the highest score. Then create a loop and an update query in code which updates the rank appropriately. Let me know if you need more detail.