I really need some help with this one as I am under a time crunch to resolve. I have two tables with the exact same fields, just different data. I want the user to be able to move ONLY ONE record from table A to table B, how can I do this? I have an APPEND QUERY set up but it wants to move all the records over. I would like the user to select the record by its Key or autonumber.