Trying to avoid multiple posts on the same subject. I am asking the same question a new way.

I have two open forms (one is a popup) each representing values from a different table. As I cannot really change the existing structure of the DB, I want to populate a third (NEW) form with 3 values from FormA, and several from FormB, and have that data update existing records in the table connected to FormB, upon exit and confirm.

MissingLinq from this forum was very helpful a few weeks ago in helping me to draw data into a new form from an open form, but in re-reading his previous posts I am unable to grasp the concept enough to move it forward to this application.

Although this forum has helped me to gain ground in the use of VBA, I must admit that I am extremely weak in parsing the code I see here. Any help is appreciated.