Expert: Scottgem - 11/3/2009

Question
I am having a record in a table and would like to edit that record and save it as a new record and not override the original record.I created a modified date field.  How can i do that?. Thanks

Answer
Copy and paste the record as a new record then edit it.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA

One of the drawbacks of getting help on a site like this, is the answerer can only go by what you tell them. You asked a fairly straightforward and simple question, so that's the only answer I could give. But if the answer doesn't meet your needs, there is a follow up option to redfine your question. You should have used that option to provide the additional info in your comments.

So what you do is provide a button on your form to copy the current record so the user doesn't see what's going on behind the scenes.

Also, there are audit trail samples available on the WEB. At a base level, you can just record the date/time the record was edited and the user who edited it. Or you can go to the nth level and record the table, field, old & new values as well as the date/time and user.

Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA