Moving Records To Available Table

[Guest_imported]

Greetings:

Bit of trouble here. I have a standard form with several different text boxes... etc... I would like to have a button that will send all the information that is loaded for that record sent to another table and truly removed from it's original table. I call it Archiving... I don't know what Access calls it.

I looked at the Append Queries and that just isn't quite what I am looking for.

I know that is simple... all I want to do is move the record that I am looking at to another table. Jeez...

Thanks all very much!

Cheers!

Mark

 

[raymondo]

What about an append query into the new table followed by delete query on the old table? Raymondo
raymondo@rossar.net