Backup?

[Benny Wong]

Hello All,
I'm using Access 2000. I have a subform in which the user uses to edit the data. Is there a way in which if the user deletes any data from the subfrom that data is copied into a "hidden" backup table of deletes? What would the method or code to accomplish this. Thanks for your advice and time in advance.

 

[Jack Cowley]

I would save the data in a hidden memo control on the form and this article will show you how to do it.

hth,
Jack

 

[Benny Wong]

Hello Jack,
Thanks! Just what I was looking for, appreciate your help.

 

[Jack Cowley]

You are welcome. Glad I could help...