In a MS Access Event Procedure I am reading the contents of a table and need to update the corresponding records in another table. I can update the first record but the remaining don't update I believe because I am not finding the corresponding record to update and the one that does update is just the first record in the table.
The current code with an explanation at the top is attached. I do not want to use SQL for the update.
I have spent a few hours trying to solve this on my own.