Deleting items from Continuous forms

[Perceptus]

According MSDN when a user chooses to delete or cut a record, that record is moved into a temporary location and then the user is prompted about whether or not they want the record to be deleted. Can I suppress the temporary move of data to this buffer, like with how it would work in a Microsoft Access Project.

I would like to copy the data first into another location before the move is made or before delete occurs without having to create a new button etc.

[rpeare]

why copy it, why not just mark it as a voided record and not display it, then you don't have to worry about extra code and it will still be in a location you can get to it in your database (on the same table it always was, just suppressed if the 'void' flag is set.

[Perceptus]

Adding another field to the table that stores this information would greatly overcomplicate and require recoding of large amounts of code. Which does seem where I this might be headed.

[June7]

Either means database changes. If you want to 'copy to another location', is that a new table? Can trap delete action with BeforeDelConfirm event, although not sure how you can leverage that to do what you describe.

I agree with rpeare, add a field for record status and modify queries - easier.

[rpeare]

If you want to do what you propose you can do one of a few things

if you put a 'delete' button on your form or trap the 'delete' key press you would:

1. Have to copy the 'current' record (assuming this is a bound form) to a secondary table that had the exact same structure as your current one with the exception that the PK field would not be an autonumber it would instead because a long integer in case you have any tables that rely on the primary key of the 'main' table.
2. confirm (through code likely) that the record had been copied, just to make sure it had happened
3. delete the 'current' record

Keep in mind all the data in the secondary table is now pretty much useless because you can't paste it back into your main table if something was deleted by accident.

Are you sure that's what you want to do? especially on a bound form (which it sounds like you are using)?

[Perceptus]

The concept of using the button is pretty understood. I had hoped that my wack idea was a possibility. The database that I maintain has code that would appear to have operated previously in the nature of my first post. This code no longer works due to the temporary memory. I had hoped to not need it upgraded. My options are very limited. Thank you for the suggestions.