Macro calculation and Automation Object Error

[lscheer]

I'm trying to run a calculation on a field in a subform that uses data from the subform and the main form. In the subform, the calculation works (so I have the syntax correct), but when I try to run the Macro from the AfterUpdate or OnChange events from the field I use on the main form, the error message reads "cannot find Automation Object [field in subform that is used as a condition in the macro]. Why is this? There shouldn't be any Automation objects in any of the forms/subforms I have. Thanks.

 

[Rich]

Access probably cannot find the subform field post the code.