(Access) VB script for button

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

Welcome to the forums. :wave:

Are you familiar with writing SQL INSERT queries and SQL DELETE queries?

It sounds like that would to the trick for you.

Have a look at our Database FAQ section.