I am trying to add a calculation field to a form in access. Trying to
calculate total number of cases ordered times total pounds per cases
with a grand total. The expression used is
=Sum([ORDER_CASE])*[JENPROD]![Gross Weight] but getting error message
The expression On Open you entered as the event property setting
produced the following error: The object doesn't contain the Automation

object 'JENPROD.'.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]
*There may have been an erro evaluatin the function, event, or macro.

Any help that can be provided would be greatly appreciated.
Thank you.

What are you doing here? Are you trying to sum something off a
sub-form? Is JENPROD the name of an object on your form?

(E-Mail Removed) wrote:
> I am trying to add a calculation field to a form in access. Trying to
> calculate total number of cases ordered times total pounds per cases
> with a grand total. The expression used is
> =Sum([ORDER_CASE])*[JENPROD]![Gross Weight] but getting error message
> The expression On Open you entered as the event property setting
> produced the following error: The object doesn't contain the Automation
>
> object 'JENPROD.'.
> *The expression may not result in the name of a macro, the name of a
> user-defined function, or [Event Procedure]
> *There may have been an erro evaluatin the function, event, or macro.
>
> Any help that can be provided would be greatly appreciated.
> Thank you.