Recalculate after UNDO

  • Thread starter Thread starter person
  • Start date Start date
P

person

I designed my Form to RECALCULATE fields when they are updated. (For
example, when someone changes a price or quantity, the Form recalculates
the total price.)

However, if the user then uses an UNDO (either as a hot-key, or by
selecting it from the pull-down menu) it does not trigger a recalculate, so
the calculated fields (such as total price) are now incorrect.

I imagine this is a commonplace problem. Is there a clean solution?

Thanks in advance for your help.
 
Try placing a function in the ConditionalFormatting of the control you are
summing.
To gurantee that the function fires, include the field name as a parameter.

E.g.
Expression Is|sumMyField([MyField])

You will probably get a lot of calls in continuous form / datasheet view,
but the sum will be updated.

Note, I've not tried this in continuous form/datasheet view, so no promises.
Let us know your findings, Graeme.
 
Back
Top