	AllExperts > Using MS Access
	Search

About Scottgem
Expertise
I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.

Experience
I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.

Organizations
Author of Microsoft Office Access 2007 VBA
Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing

You are here: Experts > Computing/Technology > Business Software > Using MS Access > ms Access

Using MS Access - ms Access

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

Add to this Answer Ask a Question