In a form I have a sub form that displays data based on a drop down in the main form. It shows the results of the query fine in the subform. After entering results from an event I would like to be able to click on a command button that would calculate Place based on the final score. The subform can have either 1 record or up to eight records. Their best score is stored in a field call [Final score] and I have a field called [Place] to store its value. Right now I look at the best value and have a drop down with values 1st to 8th place - plus a few others like DQ, Did Not Finish etc. and choose the correct value. Can this be done with a procedure tied to a command button or am I looking at to big of a solution to the problem? If I can can you point me in the right direction on how to do it?