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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Creating Checkbox Fields For Every Record 0
Duplicate Record with Primary Key 1
Need combo box to refresh when moving to new record 2017 1
How to set different combo box values for new record? 6
Lookup current record with ComboBox, any changes create new record 3
How to export table from outlook into ms access table? 0
Updating more than 1 record at a time 1

Back
Top