Q:
data copy - paste from the same table not showing in a subform
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
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
ASKED:
Jun 30 2009 3:50 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
If you are using one form with an embedded subform to display the data of two different tables, then there must be a common relative field. I think thats the issue there, when you are copying data to the sub table the data that should be in the main table is missing. This is just an assumption as the whole scenario is not explained in the question
Browse IT Answers by Topic
