one record in a form, save values in 2 tables

[1308057]

Hi, applogizes if this command is too obvious.


I have 2 tables, one is for original record history, the other is for updating.

Thats why I want to keep both tables.

How can I write a code/command that by clicking a Save button on a form (created from tbl 1) that, not only save record on table 1 but also table 2?

(P.S. the 2 tables are seperated, without any relationship)

 

[John Big Booty]

You will need an update/append query to add the data into your second table, that will run when you click your button.

This assumes that your form is entering data directly into Table 1. Otherwise your button will need to fire two queries, one to add data to each table.