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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top