text/field

[bleep]

Ive got two groups of toggle buttons on a form, the first group i
called probability and contains 3 toggle buttons (valued 1-3) and th
second group is called cost cat and contains 5 toggle buttons (value
1-5). When i click the toggle buttons (one in each group) a simpl
calculation is carried out in a text box called severity. I've put th
following formula in the severity text boxes control source:

= [Probabilty] * [Cost Cat]

This works fine on the form but the value worked out in in severity i
the form is not being copied back in to the severity field in th
table.......does anyone know how to fix this please im having a lot o
trouble trying to fix it...any help would be really appreciated, thank
Fay

 

[Rick Brandt]

Ive got two groups of toggle buttons on a form, the first group is
called probability and contains 3 toggle buttons (valued 1-3) and the
second group is called cost cat and contains 5 toggle buttons (valued
1-5). When i click the toggle buttons (one in each group) a simple
calculation is carried out in a text box called severity. I've put the
following formula in the severity text boxes control source:

= [Probabilty] * [Cost Cat]

This works fine on the form but the value worked out in in severity in
the form is not being copied back in to the severity field in the
table.......does anyone know how to fix this please im having a lot of
trouble trying to fix it...any help would be really appreciated, thanks
Faye

A control either stores its data in the table *or* uses an expression. It
cannot do both at the same time. You have no field in your table named "=
[Probabilty] * [Cost Cat]" so why would you expect that to store anything in
your table?

The good news is that you don't need to (nor should you) store this value.
Proper database design dictates that you (almost) never store values easily
derived from other values. Any place you need to see this value just use the
same expression you now have on your form and delete the field entirely from the
table.