How do I get a calculated value in a form to update the table (ie.

K

kascool

In the form I have a box for "Open Qty". In the box I entered [Ord Qty]-[Qty
Prod]. The correct value for "Open Qty" is displayed on the form but the
table is not being updated with the value. Yes, I am a newbe with access.
 
R

Rick Brandt

kascool said:
In the form I have a box for "Open Qty". In the box I entered [Ord
Qty]-[Qty Prod]. The correct value for "Open Qty" is displayed on
the form but the table is not being updated with the value. Yes, I
am a newbe with access.
Click to expand...

Then you need to know that such a calculated value does not need (nor should it
be) stored in your table. Just use the expression you have now on your form any
place you need this value and delete the field from your table entirely.
 
Top