First off, I am not a VB programmer. At my office one of our employees needed an update to an old program they use to update an Access database. The user has a form that lists different fields ...

This would be very easy to do using some VBA code (a "module" in Access, which you can then run from a "macro"). Basically, query the two tables into Recordsets, and loop through them.