There are a couple of ways to "save" the calculated values.
1) Make a table for the data that can change and keep track of it there. For
example, if the sales tax rate changes, in the table you would place the
date of the change and the new rate. You could then use the date of the
invoice to go back and look-up what the tax rate was on the date of the
invoice.
2) In the form with the calculated textbox you would use the BeforeUpdate
event of the form to change the value in a textbox that is bound to a field
in the table. You would set the value of this textbox to the value of the
calculated textbox. The field in the table would be your "saved" calculated
value. This could be modified to only save for new records, not changed ones
if you wish. To do that just check to see if you're at a new record (If
Me.NewRecord Then)
--
Wayne Morgan
Microsoft Access MVP
"douh" <do**@tskgrinding.com> wrote in message
news:8c*************************@posting.google.co m...
I know that this is not the way, however I need to save certian
calculated values so that they do not change over time, ie. new tax
rates etc. This is for an invoice header and invoice subform. I have a
form myheader and mysub that are linked via a invoice number. mysub
calculates qty * list = extprice. I am summing these into a sum_ext
field in mysub footer. I need to have this value updated into the
myheader invsubtot. I have tried many variations to get this but the
closest I have come is to have it updated AFTER the second transaction
to the FIRST transactions value. Is there a way to use on change
control of the mysub in the footer to trigger an updating of invsubtot
in myheader or something? I have been banging on this till I am going
in circles. Thanks ahead of time for the help.
