How to delete a record in one form and add it to another from.

[123rose]

Hi Access Experts,

In MS Access, I have 2 forms with identical fields. One form is for record storage, the other is for trash can. Anything deleted from the first one should go to the other one. How can I compile the code in the on click event precedure if I design a botton for delete records.

Please let me know via: rzhang@rwbeck.com or xiulian_2@yahoo.com.

I very appreciate it.

Rose

 

[Darrylles]

Hiya,

Why do you want to display a record to be deleted from one form on another form?

Beyond me.

Simplest way I think is to create an identical table - called trash, and copy the record to be deleted from tbl1 to tblTrash - then delete it from tbl1.

Then retrieve the record into the 'Trash' form.

If you are woried about deleting records, remember that you don't ever need to DELETE records as such.
You could have a yes/no field called 'DELETED?' in each record, and if it is true then never bring it into a form or report.

When a user wants to delete a record - you just set this 'deleted' field to 'YES' - it'll never be seen by the user again (but it's always there in the tables).

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."