T
tskb
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.
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.