Well, if you delete a record, it is impossible to have a report showing that
record.

In the delete section of the code, you need to test for whether or not the
record is a new record.  If it is then Me.Undo should work to "clear" the
record.  If the record is an existing saved record, then do you really want to
delete it or do you want to reset the record back to its original values?  If
you don't want to delete it, then Me.Undo works again.

If you really do want to delete the record, then
   DoCmd.RunCommand acCmdDeleteRecord
should delete the current record.

I'm not so sure that the UNLOAD event is the proper place to try any of this.
 By that time the record has probably been saved, so it is probable that
Me.Undo won't do anything.

I would rather use the form's Before update event to make this decision.  You
could set a form-level variable that could be read by the unload event to
cancel the unload event.  You would have to reset the variable in the form's
current event so you could close the form.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

Although you can't print a report about something that doesn't exist any
more,  you could set the form's Properties so that it does not allow
deletes, instead, using a custom button, you could run an Append query which
appends the record to an archive table then deletes it from the main table.
One of the fields in the Archive table should have a date Time field
formatted to show both date and time and having the Default Value as
Now()
so you can check which records were changed/deleted. Print off your report
before deleting the records from the Archive table.

Evi

PS If this works, have a go at answering my question in formscoding, it's
driving me batty!

<daniel12k@googlemail.com> wrote in message
how can i delete a record from a form and have a report showing all
the deleted records?