Undo Delete Records

[accessman2]

Hi,

I have a question.

How can I make undo delete records?

When the user select all the records, and then click "delete" key. Then it will delete all records.

I want to setup that there must be at least 1 record left.

If they select all the records and delete all, then it will undo delete all records. We have to keep at least 1 record.

What command to undo delete all records?

Please let me know, thanks.

 

[KeithG]

I don't think this is possible in Access. There is no history logging feature.

 

[accessman2]

So, what method I can prevent to delete all records.

Me.allowdeletion = False

But, I want to delete record if the user doesn't select all records.

Does anyway to do that?

 

[KeithG]

How are they deleting the records strait from the table? Access dosen't support and trigger capabilities .