Advertisement

04.09.2008 at 12:53PM PDT, ID: 23309517
[x]
Attachment Details

Update or Copy 1 record into another record in the same table. Where id is different

Asked by kfschaefer1 in Access Coding/Macros

Tags: MS, Access, 2003

I have a subform that the user wants to be able to enter the data once in RecordID = 1 and have the option to update the remaining records for a particular mainform.RecordID ( may have multiple records linked to that RecordID), since the record for the subform will already exists with atleast the subform. RecordID.  How do I successfully update the existing records from data within the same table.  Source TAble will be the same table that will need to be update.  I am currently getting error, that the table is currently open and can't update.

Does anyone have a good work around,

KStart Free Trial
[+][-]04.09.2008 at 11:30PM PDT, ID: 21322160

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.09.2008 at 11:34PM PDT, ID: 21322194

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.10.2008 at 09:36AM PDT, ID: 21326691

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Access Coding/Macros
Tags: MS, Access, 2003
Sign Up Now!
Solution Provided By: kfschaefer1
Participating Experts: 2
Solution Grade: A
 
 
[+][-]04.28.2008 at 11:11AM PDT, ID: 21456173

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]04.28.2008 at 05:35PM PDT, ID: 21458773

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628