I have a calculated field called Saving which I want to store in the table. I know this isn't advisable, but I need to refer back to it constantly and want to know what the savings are when the information was entered. Does anyone know a way to do this?

First, add a field to the appropriate table where you will store your calculated field.

Second, bind your calculated control field to that form.

Third, make that control calculated field locked.

Fourth, write a VBA procedure that does the calculation. For example:

Me!CalcField = Me!Cost - Me!Discount

Fifth, set before update events for each field used to do the calculation that call the procedure you wrote above.

Sixth, set the on enter event of the calculated field to also call that procedure and do the calcuation. This should be unnecessary but it is an extra safety step.