Use data from subform in update query

[tagteam]

I have a form that I use for reconciliation and it has 4 subforms on it. Sometimes I want to update data in the main table based on what appears in the subform. However, When it try to reference the subform in the update query it does not work.



When i Run it a box pops up: Enter Parameter Value and has the code i used to pull the value Forms!my_subform!fieldname as the description. If I enter the data in the parameter boxes it does update correctly, however, it is not pulling the existing value from the subform, which is what I want it to do.

Thanks for any help

[ranman256]

use the BUILDER to insert form parameters into the query. It never gets it wrong.

but the subform objects look like: forms!fMainForm!subfrm.form!cbobox

[tagteam]

Ahh, yes, forgot about using the builder. I will try the builder / object string you mentioned. I forgot to include the subfrm.form part.

[tagteam]

Ok, tried the builder and it gave me the same thing I had built out and I tried adding forms!MainForm!subform.form!field but it doesn't allow that. Once I select forms!MainForm it only gives me options for fields on that form, not another subform.

[tagteam]

I thought the problem might be because I was using a datasheet view for the subform but even in single form view it doesnt work.

[Micron]

I couldn't recall seeing the builder being available to the query parameters so I took a refresher look. Turns out it's not - at least not in my version


Are you sure you are trying to define the parameters of the query?

[tagteam]

I kind of got this work by using a dlookup. On the main form I have three unbound fields. I use a dlookup for the data and lookup the data I need from the subform. So it displays in the subform AND in the main form. Then i can confirm the data and use a regular update query to update using the three unbound fields.

I never did get the update query to be able to pull the data from the subform and use it in the update.