Moving Records of one table to another

B

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.
 
J

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.
Click to expand...

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]
 
B

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
 
J

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
Click to expand...

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]
 
Top