How do I transfer data from a control of a sub-form to the parent with a criteria where the Item ID is identical?

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...

Hi DBguy, thanks so much, you always solved my problem(s). I used an update, all working well.

Hi,



Glad to hear you got it to work. Good luck with your project.