I am running an update query. One field updates the other field. When I print the report the macro prints the report and runs the update. However, if I move on the to the next report it will update my new information and update all the other records. Is there any other way to lock the rest of the records and only update current?

Your update query needs a parameter. Assuming that the record you want to update is the one visible on the form from which the report is run, just add a reference to that record to the update query.

Where SomeField = Forms!YourForm!SomeField;

So far that works great, thank you.