I have a form based on a query and some of the form controls display the results of calculated fields in the query because the user wants to do a visual check of the results. The user wants the ability to override the calculation and enter their own figure if they desire. That figure would need to saved in place of the calculation in the underlying query because those values will be summed in subsequent query.
Has anybody had to deal with anything like this? And, if so, what was your strategy?
E
