NMEX,
A calculated field should never be saved to a table. It should not be bound to a field
at all.
Here's an example just like yours...
Price * Qty = Line Total
You wouldn't save LineTotal, just save the Price and Qty.
You would place an unbound text control on your form named LineTotal with this
ControlSource...
= Price * Qty
This will always "display" the correct LineTotal on that form, AND if Price Changes or
Qty changes the Line Total will update and display automatically.
Now... in any subsequent query, form, or report... based on the data you captured,
LineTotal can be re-calculated from the stored Price and Qty.
For ex. later on you have a report to show Sales. A calculated field on that report
with the same...
= Price * Qty
will alwys give the correct results.
