Does anyone know where I can find any code that changes a given text box according to what the other ones say? What I am doing is getting a record set from a database that has rank as one of the fields. Rank is in a dropdown list with numbers 1-20 in it. It prints out the current rank in the box. What I want it to do is recalculate the rest of the ranks in the recordset and then update all records. a record has a rank and it is displayed in a dropdown list <BR>eg<BR>ID Name rank<BR>1 TJ 1<BR>2 BP 2<BR>3 CT 3<BR><BR>The rank appear in a dropdown list which can then be edited so if I want to change TJ&#039s rank to 3 then BP and CT will recalculate to display the following<BR><BR>1 TJ 3<BR>2 BP 1<BR>3 CT 2<BR>I don&#039t know where to start. Please help!! <BR><BR><BR>