The database is a lending library. I wish certain records to be archived to a duplicate table, so I can create history of items people have lent.

The database contains name, item lent, date lent and date returned. When a command button is pressed it will only archive records that have a return date in them.

I have tried to use the 'After Update', to set a flag, and when the command button is pressed it checks if it has been set, but I just cant get it to work. I can do the other bits, such as Insert int otable.

Any help would be appreciated.

Just guessing here, but are you storing all the data in one table....?