John, thanks for the response, I need the data stored because it is used later to build a report.
That would be true IF you had to have data in a table in order to
report it. YOU DON'T. If you can do the calculation on a Form you can
do the calculation in a QUERY, and base your report on that query; or,
you can do the calculation on the Report in precisely the same manner
that you did on the form.
I also tried using a setvalue macro to get the info from the field instead of using the control source. I am unable to get that to work - I believe I may not be able to set values from one subform to another? My biggest concern is that I need to print a report that would supply this information and you can't build reports from anything but tables or queries and if the info isn't there, then I can't report it? Is there a way to get it into the table?
Your assumption about reports IS COMPLETELY INCORRECT. It's a common
assumption, but it's still wrong.
Yes, you must base a Report on a Query; *but* you can a) put
calculated fields in that query or b) set the Control Source of report
controls to an expression, exactly as you can do on a Form.
If you INSIST on storing the data in a table (and there are good
reasons to do so, though needing to report that expression is *not*
one of those good reasons), you can use VBA code in the Form's
BeforeUpdate event. Set the values of bound controls to the calculated
field values:
Private Sub Form_BeforeUpdate(Cancel as Integer)
Me!txtBoundPrice = Me!txtCalcPrice
<etc>