Copy unbound field value into bound field

I have a typical OrdersMainForm with a subform showing individual
items orders in rows.

The subform footer has a calculated field (Subform_calc) that sums the
individual orders in the subform.

OrdersMainForm has an unbound field that reflects the total order
amount (the value from Subform_calc, in the subform footer).

The unbound field on the main form contains this expression:
=SubformName.Form!Subform_calc

I don't understand properties/methods, but I think this works because
I am getting the "value" property from the Subfrom_calc field

This is my question.
I want to "pop" the value from the unbound field into a bound field on
the main form.

I thought I could use a SetValue macro action.
Item I used: Bound field on the main form
Expression I used      =[Unbound field on Main Form]

Result was nothing.
Then,
I played around with it but repeated got a message like this:

"Doesn't contain the Automation Object"
"Visual Basic tried to set a property or method for an object"
"component does not make the property/method available for automation
operations."
"Check the component's documentation for information on the
properties/methods it makes available for the Automation process."

Thank you in advance for any light you can shed on this.

I don't even know what my "component" IS.

What is the component whose documentation I should check for
properties/methods it makes available for the Automation process.?


Reply via email to