How do I transfer data from a control of a sub-form to the parent with a criteria where the Item ID is identical?
Mar 11 2012, 10:23 AM
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...
Mar 12 2012, 12:22 AM
Hi DBguy, thanks so much, you always solved my problem(s). I used an update, all working well.
Mar 12 2012, 10:06 AM
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.