Using for to append modified records to new table

[Bev]

I have a table with thousands of records. As these records are reviewed
additional fields are populated. As these fields are populated, I want them
to append to a different table. How do I achieve this?

 

[KARL DEWEY]

As these fields are populated, I want them to append to a different table.
Fields are not appended, only records.
Why are you not using that table to start with?

Explain a little bit more about your operation and someone might be able to
suggest a better method.

 

[Bev]

I am using it for all records. I only want append those records with
modifications to a new table

 

[John W. Vinson]

I have a table with thousands of records. As these records are reviewed
additional fields are populated. As these fields are populated, I want them
to append to a different table. How do I achieve this?

If you're using a Form to "populate" the additional fields (as you should
be!!) you can use the AfterUpdate event of the form to either run an Append
query to copy data from this table to the other one, or open a Recordset based
on the second table and fill it from the form controls.

But... why are you storing the same data redundantly in two different
tables??? That's almost always a Very Bad Idea.

 

[Bev]

The source data gets replaced on a weekly basis. I need to save a historical
view of the data.