Work around for Delete query on a bound form

[Opal]

I am trying to figure out the best work around for running a delete
query from a bound form.

User inputs data into frmProduction bound to the table Production.
This data details items needed to be sent out for repair.

The user that sends the item out for repair, opens frmRepairOrder
bound to table RepairOrderTemp. When the form is opened,
an append query is run as follows:

INSERT INTO RepairOrderTemp ( ProductionID, CassetteID, CassetteNoID )
SELECT Production.ProductionID, Production.CassetteID,
Production.CassetteNoID
FROM Production
WHERE (((Exists (SELECT RepairOrder.ProductionID
FROM RepairOrder
WHERE Production.ProductionID = RepairOrder.ProductionID))=False));

This brings only new repair requests from Production into a Temporary
table.
The user sending out the item for repair updates their records with
the
date sent and their name....etc. When the user updates these records
the data is sent to the RepairOrder table and I now need to delete it
from
the temporary table. However, because the frmRepairOrder is bound to
RepairOrderTemp, the delete query will not run. Since I am using an
autonumber field in the RepairOrderTemp table to track each repair
record
I need the form bound to the table. Is there another way to approach
this
that is user friendly and elegant?

 

[NetworkTrade]

the action that sends the data to the RepairOrderTable can trigger a delete
query for the TempTable.

one can trigger a delete query to any table regardless of what form is bound
to whatever.....