Full Version: Transfer A Subform Control To The Parent
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
foxtrojan
How do I transfer data from a control of a sub-form to the parent with a criteria where the Item ID is identical?
theDBguy
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... 2cents.gif
foxtrojan
Hi DBguy, thanks so much, you always solved my problem(s). I used an update, all working well.
theDBguy
Hi,

yw.gif

Glad to hear you got it to work. Good luck with your project.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.