Form Calculated fields

[Askie]

I have a form which is bound.
There are three fields related thus:

Impact - either 1,2,or 3
Urgency- either 1,2,or3
RAG - the product of above two (impact *urgency)

How do I get the form to Save the calculated value without me having to manually put the result in the form field i.e. entering 9 if impact=3 and urgency=3
I am using Access 2007

 

[jdraw]

What exactly do you mean by this

How do I get the form to Save the calculated value

Data is stored in Tables. Forms are an interface technique that presents data from Tables and/or Queries to the user.

If you can calculate a value based on a number of fields, the recommended practice is to do the calculation in a query( or function) whenever the calculated value is required. Do not store a calculated value in a Table.
If you have rare and unusual conditions, you may store a calculated field, BUT normally this is NOT done.

 

[YNWA]

Recreate your table in a query and then do the calcs from there.

Do not store calc fields in tables. Bad practice.

 

[MStef]

Yo don't need to save calculated value, because you can calculate it always you need it.