Form Calculations

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I have a form that has 4 calculated fields on it. I would
like these calculations to go into 4 fields in my table.

How do I tell the calculated fields to send the numbers to
the other fields in my table.

Thanks in advance.

DaveB
(e-mail address removed)
 
Dave,
First, in most instances, you don't "save" calculations in a table. If
you had Price and Qty, you wouldn't have to save the LineTotal (Price*Qty).
Since you've captured Price and Qty in your table, you can always
"re-derive" the LineTotal... "on the fly" in any subsequent
form/query/report/ etc..

You don't indicate what fields go into your calculation, so let's use my
example above, and you apply it to your form/field names...

If you MUST capture the calculation, remove the calculation in the
ControlSource of LineTotal, "bind" the control to your LineTotal field, and
on the AfterUpdate event for EITHER Price OR Qty...
LineTotal = Price * Qty
That way, if you enter (or change) either Price or Qty your LineTotal
field will be updated and "captured"
 
Back
Top