Using form to update two different tables

[Bigdaddrock]

In the interest of avoiding data entry errors, I am seeking a means of entering data (in this case mail address data) into a form , with subsets of that data being recorded into two separate tables.
I cannot merely record the Record ID of one table (with the details) into the second table, since I must "freeze" the data in the second table at the time of entry, while the first table's record may be revised at some later date. (The first is a customer's address details, while the second is for issuing an invoice. The latter must remain unchanged going forward, while the Customer's current address file may change.)
Thanks for the assistance.

[gnawoncents]

Let me see if I understand. To oversimplify it, let's say you have three fields in the form:
- CustomerID
- CustomerAddress
- InvoiceNumber

You want to fill out the form then take CustomerID and CustomerAddress to populate Form1 and CustomerID and InvoiceNumber to Form2.

Then if you were to fill out the form again for the same CustomerID you need the info in Form1 to be updated as necessary with any address change and a NEW record appended to Form2 with CursomerID and the new InvoiceNumber.

Is this what you want? If so, it can be accomplished by running an update and append query when the form closes or you click a button or whatever you choose. The update query for Form1 and an append query for Form2. If this isn't what you're looking for, please let me know.