How do I run an Append query that will get fields out of one table, based on a paramater, and then update a table while changing one field value to a second parameter.

I have made the query, but I cannot run it without being prompted. How do I programmatically run this Append Query that accepts parameters?

David.