I have an Access 2007 application for recording employee skills and competencies in a medium business. We have recently duplicated the application with a view to recording other employee skills of each employee. Normally, I would add each employees details via a form and an embedded subform, however to save time, I have tried to add data by using copy and paste in the subform data table. As a trial, on this occasion I copied a set of data in the subform data table and then used paste /append to add the data to the same table. I then modify the new data to make it employee specific i.e. name etc. The process works and looks fine in the database, BUT the copied data does not appear in the subform that normally feeds the table.
If I add the data manually using the subform then everything works just fine. So, my question is, how can I make data copied and then modified in the same table an mentioned in the manner indicated above, appear in the subform when viewed.
Many Thanks in advance