Move record to other table

[Hassan]

hi everybody...

i'm a new user in access. i'm trying to make an data entry program. in this
database there is a table named 'active vehicle". i've put one field removal
date to
the form for unactive. when i there is any data in that field then that
record should move to other table "Removal", is
there any way to do that? i'm waiting for your helps.

thanks in advance.

 

[Allen Browne]

The easy way to do this is to add a yes/no field to your table. Name the
field (say) Inactive. When a vehicle becomes inactive, check the box.

It's very easy to create a query that returns only the active vehicles, and
use it anywhere you currently use your table.

If you really want to move the inactive vehicles into a different table,
here's how to do it safely:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html