calculate totals in forms

S

Scott

I am new to creating forms with calculations. I understand the concept of
naming the fields, etc. When i place a "calculation field" into the form, and
write the calculation such as "+A2*D2" in cell say E2, upon exiting the
editor it will calculate the cell. But when runing the form in protected
mode, where you allow form fileds only to be filled, it will not reflect any
changes to the total, or update it.

The same is true if trying to calculate a total for a column, etc.

What am I missing?
 
G

Greg Maxey

Scott,

Unprotect your form. Double click each variable field and check "Calculate
on exit" then reprotect.
 

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

Top