Transferring or moving records

I have data in a temporary table and on completion of a transaction I want
to transfer the data (based on a UserID) from my tmp table to the 'main'
table.
I am using Access 2000 and DMX.
I have created an update query and then a delete query but I'm not sure if
this is the right way to do it or how to 'run' an Access query on submission
of a form. Any help would be much appreciated. Thanks.