Ok, kind of stuck here. I am looking for a script to embed in a button in access that will take the current record seen on the form and copy it to a historical table. Then once the move is complete delete the record from the original table. All query appends have come up short and I am not as advanced in VB script as I thought to get this one. Any ideas?

Thanks