Archiving Records (1 Viewer)

[123James]

Hi guys

I need some help working out a way to archive records. All i really want is a button on a form that when clicked deletes the record currently displayed on the form from its table and moves it to another table that i will call 'archives'.

I think it might have something to do with using an append query but i cannot think how to do it.

Thanks in advance.

James

 

[RuralGuy]

Please do *not* post the same question in more that one forum. Answered in your other post.

 

[gemma-the-husky]

are these plain records, or are there linked records to the ones you are taking out (eg orders)

why do you need to archive, generally access looks after itself, and there are no speed issues from leaving data where it is?