Moving Records of one table to another

[Beatrix J B]

Hi!

Where can I find an example where in if i push a button on a form ... it
would transfer the selected record to another table.

Thanks.

 

[John Vinson]

Hi!

Where can I find an example where in if i push a button on a form ... it
would transfer the selected record to another table.

Thanks.

The button code could execute an Append query.

However... it's VERY likely that your table design is flawed, if you
need to do this! Storing the exact same record values in two different
tables would be redundant, and redundancy is Evil.

What are these tables, and why is this operation needed!?

John W. Vinson[MVP]

 

[Allen Browne]

See:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

The article explains how to avoid doing this.
It also gives details on how to do it safely (Append and Delete queries
exectued in a transaction.)

 

[Beatrix J B]

Actually ... after pushing the button ... would like to transfer the record
or copy some of the fields in that record to another table and delete the
record

 

[John Vinson]

Actually ... after pushing the button ... would like to transfer the record
or copy some of the fields in that record to another table and delete the
record

See Allen's response then.

I still suggest that this may not be necessary. It's often just fine
to just add a yes/no field Archived to your table; if you want to
"move" a record out of sight, base your forms and reports on a query
selecting records with Archived = False, and set the field to True to
hide it.

John W. Vinson[MVP]