Query to update 2 tables

[BEJ]

In my db, access 2007, I have two tables setup "Input" and "Payment_Details".
What I want to happen is when a user enters an item into the the "Input"
table the Vendor field is automatically added to the "Payment_Details" table.
I have setup an append query, but how do I make it run when the "Input" table
is updated or can I. I started on the following macro, but I do not want my
users to have to remember to hit run macro.

Docmd.SetWarnings False
Docmd.OpenQuery "Add_query"
Docmd.SetWarnings True

Thanks for the help!

 

[BEJ]

Please ignore my post, i figured it out. I was just overlooking what I needed
to do