Sorry Mike, I can't give a definite answer.
But, there may be a problem with the linking of the two tables. Are the relationships between the tables set to update automatically? In the Relationships display, right click on the link and check that the properties are set correctly.
A *very* good site for Access problems is click here You need to register, but there is no fee and there is no pester -mail from them. They're we;; worth a visit and questions do get picked up on quickly.