I have set up a simple form which I want to use for inventory purposes.

Each item is stored at the warehouse for a certain amount of time, before it is bought back to the production unit for work to commence on it.

I would like the ability to move a record from the form that shows all of the items stored at the warehouse to a seperate archive form of records that shows all of the old items that are no longer stored at the warehouse.

Is this possible?

Many thanks
Tom