Hi Delerna

Many thanks for your response.

The [autosum] control on the form is bound to a calculated field in the underlying query and not from the table - so the value isnt saved into a table. I simply want a means of overriding the calculated value to allow for flexibility - which is required for this particular application. The value that is entered into [total] will be saved however as this value may be manually entered....

Hi there

I have two text boxes on a form - "autosum" and "total". The "autosum" control displays a calculation executed by the underlying query. I am wanting to either enter this value into the "total" control via a button, or manually enter a value into the "total" control. I have read somewhere that you cant override a control when the value is the result of a calculation. Please...