Move a single record to an archive table

[10 Gauge]

I would like to make a "Kill" button that when pressed will move the selected record from my "Tasks" table to my "Archive" table which contains outdated records that are no longer being worked on.



Is there an easy way to do this?

TIA.

Edit: Preferably with a dialog box that asks if you're sure you want to kill the ticket.

[RuralGuy]

This link should help: http://allenbrowne.com/ser-37.html

[10 Gauge]

That link portrays exactly what I need to do. I have taken the code from that page and tweaked it to resemble my database and what needs to get backed up however when I run the command it returns the following error:

"An INSERT INTO query cannot contain a multi-valued field."

What exactly is a "multi-valued field" or what is stopping this from running correctly?

[10 Gauge]

It ended up being the Attachments field which I guess can not be transferred which is too bad because we attach important PDF's that should stay with the archived records.

[RuralGuy]

You should then be able to do it with a Recordset a field at a time using a query to delete the original record if successful.

[10 Gauge]

Ok thank you I will look in to that.

Another ?, is there a specific line of code to refresh the database?

I have built my Kill Switch and put the KillYesNo check box next to it, but it doesn't work unti after I manually refresh the database once I have checked the box. Curious if I can add a command in the button code that will refresh the database before it runs through it's set of commands.

[RuralGuy]

Changing a control on a form does *not* change any fields to which they are bound until the record is saved. You can do that with Me.Dirty = False if you want.

[10 Gauge]

Thank you RG, that worked splendid.