How can I combine an append and update query with user supplied info?

[Erik Pygott]

I'm trying to make a query in Access 2007 to append a record in one table to another table and include a bit of user-supplied information.

Let's say there are two tables: TableA and TableB.
TableA looks like: [ID|Name|Email|LoginID]
TableB looks like: [ID|Name|Email|LoginID|TermTicket]
TermTicket is supplied by the user, ID is taken from the form for the specific record

Right now I have an append query to copy the table info then an update query to add in the TermTicket. Is there any way to combine the 2 into one command? Would it be easy to put the info for TableA into an array for a given ID, add the TermTicket info, then copy the array to TableB?

I'm just trying to minimize update/append queries

[Rabbit]

If ID is supplied by the form for the insert then have the form supply term ticket as well. Althought the real question is why do you have two identical tables where the only difference is a column.

[Erik Pygott]

It's a bit complicated, but basically TableA is active users of an application and TableB is disabled users. When a user is disabled the LoginID in TableA is reused, but the record needs to be saved for auditing, so it gets copied to TableB with the termination ticket, then Name and Email are cleared in TableA so the LoginID can be reused. Someone using the database will find the active user needing to be disabled, click a button to set off the process. The button prompts the user to enter the termination ticket, then does all the automation

[Rabbit]

Then you already have everything you need to combine the two queries into a single insert query.