data in form not saving in table

  • Thread starter Thread starter ASSK
  • Start date Start date
A

ASSK

Please help.....

I have a text box in my form call risk grading (orginate from my table). I
had to chagne the Control Source and input an "IIF" function in there to
calculate the risk based on two other fields.

But when I checked my table, the Risk Grading appearing in my form is not
saving/inputting in my table.

How can I make the Risk Grading results save in my table????

I hope it make sense.......
 
Calculated Controls are not saved to a Field in the underlying Table -- in
fact, the Field to which a Control will be saved is specified in its Control
Source property, where, for Calculated Controls, the calculation is stored.
The designers of Access apparently assumed that if you defined it as a
Calculated Control, you would calculate it every time you displayed the
data. And, if you can calculate it from other Fields in the current Record,
and aren't trying to save it as a historical-record of a point-in-time (as
the price on an item sold in an invoice detail, the cost of which may change
over time, but the price at which the item was sold should not also change),
then you should not save it because it's redundant data.

For those rare instances where you should save a calculated value, instead
of placing the calculation in Control Source, place the Field to which it is
bound there. And, in the the AfterUpdate events of each of the Fields that
is a Factor in the calculation, perform the calculation and save it in that
Field -- you might also include in the OnCurrent event, a conditional
calculation if the calculated Field is Null, but there are values in all the
required factors.

Larry Linson
Microsoft Office Access MVP
 
I've just tried it and it didn't work.

Basically what I have is two fields in my form...Likelihood Combo field with
drop down box (Rare, unlikely etc), and Loss Given Occurrence Combo Field
(drop down box: Insignificant, Minor etc). Depending on the combination of
these two fields, the result will be transpose to another field call Risk
Grading with results such as (2&3, 4&5 etc...).

In my risk grading, I've managed to generate an iif string which i've
entered in the Control Source. The result come back perfectly, but not saved
in my table.

Question is, is there a away I can save the outcome to my table without
changing this process as it took me so long to figure this out and I am very
very amature when it come to this sort of things.

Thanks for your help.
 
Back
Top