UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Transfer A Subform Control To The Parent, Office 2003    
 
   
foxtrojan
post Mar 11 2012, 09:43 AM
Post #1

UtterAccess Guru
Posts: 677
From: Singapore
How do I transfer data from a control of a sub-form to the parent with a criteria where the Item ID is identical?
Go to the top of the page
 
+
theDBguy
post Mar 11 2012, 10:23 AM
Post #2

Access Wiki and Forums Moderator
Posts: 48,113
From: SoCal, USA
Hi,

How is the subform linked to the main form? If you're using ItemID, then they will always be identical. Are you sure you don't want an UPDATE query instead? Also, are you trying to store the same value in multiple tables?

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)
Go to the top of the page
 
+
foxtrojan
post Mar 12 2012, 12:22 AM
Post #3

UtterAccess Guru
Posts: 677
From: Singapore
Hi DBguy, thanks so much, you always solved my problem(s). I used an update, all working well.
Go to the top of the page
 
+
theDBguy
post Mar 12 2012, 10:06 AM
Post #4

Access Wiki and Forums Moderator
Posts: 48,113
From: SoCal, USA
Hi,

(IMG:style_emoticons/default/yw.gif)

Glad to hear you got it to work. Good luck with your project.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 09:01 PM