Getting a calculation in a form to update a table

Hi I have recently set up a new database but what I need it to do is a simple
calculation in a form, that will automatically update a table but when i set
it up, the form carried out the calculation fine, but it did not enter the
outcome of the calculation in the table. I am clearly doing somehting wrong
i just can't figure out what it is. The table is call Table 1 and the
formula for the calculation is
=[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad
difference] on the form, but not in the field in the table.

Please Help

Wez

Calculating the answer when you need it is the best possible solution.

If you need to see it elsewhere than in your form, create a query, and type
the expression into the Field row. Then use this query whereever you would
have used your table.

The reason this is better is that it cannot go wrong. If you store the value
in the table, and then it doesn't match, you're shot.

More information:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wes" wrote in message
...
Hi I have recently set up a new database but what I need it to do is a
simple
calculation in a form, that will automatically update a table but when i
set
it up, the form carried out the calculation fine, but it did not enter the
outcome of the calculation in the table. I am clearly doing somehting
wrong
i just can't figure out what it is. The table is call Table 1 and the
formula for the calculation is
=[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad
difference] on the form, but not in the field in the table.

Please Help

Wez

On Thu, 6 Nov 2008 04:43:01 -0800, Wes
wrote:

That's good, because in the vast majority of cases calculated fields
don't belong in a table. Why? Because they can become out of sync, and
it is very easy to recalculate in a query:
select [Pad size Rim] - [Pad size Axle] as "pad difference"
from Table1

So please delete that field from your table definition and use a query
to calculate.

-Tom.
Microsoft Access MVP


Hi I have recently set up a new database but what I need it to do is a simple
calculation in a form, that will automatically update a table but when i set
it up, the form carried out the calculation fine, but it did not enter the
outcome of the calculation in the table. I am clearly doing somehting wrong
i just can't figure out what it is. The table is call Table 1 and the
formula for the calculation is
=[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad
difference] on the form, but not in the field in the table.

Please Help

Wez

Hi Wes,

The guys are correct, the total should not be stored in the table. However,
to add to thier response, if you plan to create a report with these fields
you can also do the calculation there as well. So if no report you have the
query and if you have a report do it in the report.

Good Luck!

"Wes" wrote:

Hi I have recently set up a new database but what I need it to do is a simple
calculation in a form, that will automatically update a table but when i set
it up, the form carried out the calculation fine, but it did not enter the
outcome of the calculation in the table. I am clearly doing somehting wrong
i just can't figure out what it is. The table is call Table 1 and the
formula for the calculation is
=[Pad size Rim] - [Pad size Axle], it displays the answer in Field [pad
difference] on the form, but not in the field in the table.

Please Help

Wez