Create a duplicate entry on a Table and then edit that

[pennycarhire]

Hi, I', trying to create a duplicate of a certain record in a table so that the user can then edit the new record - or old record even as it doesnt matter - as long as one of them is original. The idea is that any revisions / changes are stored the user may of made.

Any thoughts or other work arounds greatly appreciated?

:banghead:

 

[CJ_London]

Probably not the best way to go unless you need to make use of the history in some way.

If you look at post #3 of this thread, it should give you some ideas

http://www.access-programmers.co.uk/forums/showthread.php?p=1290096#post1290096

 

[pbaldy]

FYI, moved this thread from introductions forum.