appending a new record in an access table to another table

[jdashm]

I have a project in which I need to create a new record in a table after a record is added in another table. I wanted to use Data Macros to do this but the end user version is Access 2007.
What is the best way to do this. The new record should be triggered after insert when a particular field is true.

[ranman256]

run an append query.
use the key of the one you added, and append to 2nd table.

[jdashm]

Thanks for the response. I will try that.