data copy – paste from the same table not showing in a subform

20 pts.
Tags:
Database programming
Microsoft Access
Microsoft Access 2007
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
ASKED: June 30, 2009  3:50 AM
UPDATED: July 16, 2009  4:30 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following