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.