Update two tables from one input form

[Jeff-H]

Hello,
This should be simple but I have been unable to find an answer.
I would like to input a new record on a form and update two different tables from the same input data. Both tables are identical.
Thanks for any help.

[RuralGuy]

OK, I've got to ask: Why do you have two identical tables?

[Jeff-H]

I want to add records to the main table and at the same time maintain a "transactional" table. The second "transactional" table will be cleared at the end of each quarter.

[RuralGuy]

I'm sorry for being so inquisitive but is that because you can not determine what records in the "main" table are from what quarter?

[Jeff-H]

The main database will signed off by management each quarter. After sign off and end users will add new records and also edit records. We are looking to track the changes each quarter, therefore the second table.

[RuralGuy]

I take it you do not have an AuditTrail built into this system? Assuming each record is in fact a *new* record then you should be able to do what you want in the BeforeUpdate event of the Form using another RecordSet.

[Jeff-H]

Correct - I have no audit trail built into the application.
I will be doing both:
1. opening the form and adding new records
2. opening the form with an existing record through a prior search and editing certain fields.
I want a record in each table for both types of entries.
I have not used VBA or recordset so any help would be useful.
Thanks

[RuralGuy]

I guess I don't understand what "signing off" the quarter involves. I think dates on records and an AuditTrail solves all of your issues but I could be wrong here.