I have a query that sorts data from a weigh in table and returns a single result per player based on some date and time criteria. The returned result is then used in a comparison the next time a player weighs in to determine a recovery score. Since the data from the query is based on information from the weigh in table, when I have the form run a refresh function to place the current weight in the weigh in table, it updates the query and thus returns a recent that is identical to the current. Is there a way to have the form pull only the value from the recent query and not update when a refresh is ran? In the end, I would like to create a new table called recovery where the players ID, recent weight (the one used for comparison not the new one generated), current weight, dates and recovery score are stored.