Copy (or Append) a record to a different table in Access 2007

[CindySue]

I've been searching archives, but I can't find anything I can make work, and this is probably really simple--unfortunatley just not for me. I want to have a button on a form that when clicked will copy (or append) the current record (from the table "Auction Items 2009") to a different table ("Auction Items"). I can make the button, but I can't seem to figure out what code to use. A macro would be fine, but while it says macros can execute a command on the ribbon, I can't find a way to do that. I would appreciate any help.

[missinglinq]

Having identical records in multiple tables is a major violation of normalization ruls! Why do you feel the need to do this?

Linq ;0)>

[CindySue]

The record won't always stay identical. I'm tracking donations for a silent auction, and I create a new table each year. The item they donate can different, and sometimes the name of the contact, the address or phone can change, and not everyone donates again. I copy the record from the previous year and update fields as necessary, but by having the previous years we can always look back to see what they have donated over the years.

[CindySue]

I think I missed the correct way to respond before. Please see my response above.