469,282 Members | 1,604 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Duplicate Record form button creates blank record

I am relatively new to Access (2010) and I am having difficulties in making a duplicate record button that was created with the wizard work correctly. I have a very simple database and form. To create the form with the duplicate record button, I copied a different form I created which is for new records. When I click on the duplicate record button I created, Access brings up a blank form (there is no data copied over from the previous record).

I am trying to duplicate the record so that I am able to have a historical log of all data that was entered for a particular record.

Can anyone assist with making the duplicate record work or have any alternative for creating historical records.
Jan 8 '13 #1
2 2281
Seth Schrock
2,962 Expert 2GB
Here is a link to a an explanation of how to audit record changes in your database: Creating an Audit Log

This guy really knows what he is talking about.
Jan 8 '13 #2
NeoPa
32,173 Expert Mod 16PB
OP:
Can anyone assist with making the duplicate record work or have any alternative for creating historical records.
As your question currently lacks any of the details that would be required in such work this would not be trivial. Please post what you have now with an explanation of what doesn't work and, if code crashes, where it does so. These are basic elements of any such question, that you may get away without knowing as you're a new member (Though why common sense doesn't come into play is beyond me).

Please add the required information before proceeding further.
Jan 9 '13 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

19 posts views Thread by Joe Scully | last post: by
2 posts views Thread by Harry Haller | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.