Caculated Form does not update data into a table field.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a data entry form which has the following fields and suppose to update data entered into
table that has the same existing fields. Ex. Customer ID, Customer Name, ITem Ordered,Billing Charge Payment Balance. All data entered on all the fields updates into the table except the "Balance Field". On the form I created a calculated formula such as : Balance:[Billing Charge]-[Payment] and the form shows the calculation field correctl
however, it does not update into the table although the rest of the other fields on the form updates

What am I doing wrong
 
Mercy said:
I created a data entry form which has the following fields and suppose to update data entered into a
table that has the same existing fields. Ex. Customer ID, Customer Name,
Click to expand...
ITem Ordered,Billing Charge Payment Balance. All data entered on all the
fields updates into the table except the "Balance Field". On the form I
created a calculated formula such as : Balance:[Billing Charge]-[Payment]
and the form shows the calculation field correctly
however, it does not update into the table although the rest of the other fields on the form updates.

What am I doing wrong?
Click to expand...

What you're doing wrong is trying to save calculated fields. Usually it is
unnecessary to save any calculations. The exception being when does
calculations are part of history or when the calculations take too much time
and therefore it is more efficient save them.

Typically, you store all the elements of the calculation and can re-create
that calculation and any time. If you really insist on saving that
calculation, you must push the data into the calculation rather than pull
it. To do that you see after update event of each of the fields that make
up the calculation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top