Moving a record from one table to another

[GarageFlower]

I have a database of assets.

For example a computer will have an asset .

This database will show the asset, where it is, what it is and who its with .
It will display this on a form.

When this asset gets given to someone else i want a button on the form which displays the assets current data to be clicked and for that info to be moved from the asset current table into the asset history table.

any idea what vb code would do this?

 

[Georgina]

Hi

I did exactly what you were trying to do with a purchase order database, but ended up regretting moving stuff from one table to another (mainly due to user error).

What I ended up doing was creating a field in my current table called date completed and then a command button on my form that then made that field = todays date when it was pressed.

My form was then based on a query which only included records where the date completed was null.

Hope that this helps

George