Adding Calculation Field to Form

  • Thread starter Thread starter tskb
  • Start date Start date
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.
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a calculation field to form 1
Calculated Field in Form 6
Problems with Totaling 1
Total of calculated field in a form 3
Need help on how to pass calculated field from a form to another form 0
Values calculated in a Form entered in the Table? 6
Summing Calculated Fields 11
Forms and Calculated Fields 1

Back
Top