copying new records to another table

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

Hello all,

I want to copy records to a 'copy' table whenever a new
record is added in a 'source' table.
How to acheive this?
Thank you for your insights.

Samantha
 
Access lacks triggers, so you cannot achieve that.

If all entries are made through a form, its AfterInsert event fires whenever
a new record is added. You could therefore execute an Append query statement
in Form_AfterInsert to achieve the result.
 
Back
Top