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
Software/Hardware used:
Software/Hardware used:
ASKED:
June 30, 2009 3:50 AM
UPDATED:
July 16, 2009 4:30 PM
RELATED QUESTIONS
- Update multiple tabs on an Access form on initial update
- How to insert multiple rows into embedded view from a subform?
- Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?
- Master/Child Link problem in Subform
- Using combo box to populate a sub form which is used to create a new record
Answer Wiki:
Hi,
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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
