Access Macro - What's happening??!

[Diane Herron]

I have a subform attached to a form. On the subform I am using a macro (Before Update event) where the action is SetValue, the Item is [CoBorGrossMoInc], and the Expression is [Forms]![frmCo-BorrowerInfo]![CoGrossMoIncCalc]. I get the error message shown on the attached file when I close the main form or go to the next form. The macro does work when the subform is open at the same time as the form.

Is there a way to get the macro to work without having the subform open?

 

[kbstoikop]

it is a little confusing because a subform is usally embedded in the main form.

The best way to update fields in a form is to create a hidden field on the main form and update the subform based on the field value of the main form. Since the main form should always be open the field should get the correct value.

also you should use accessvb to update things instead of macros as the macros can be limiting in what you can do