editing a calculated field

[rdeanh]

I have an order detail line that pulls manufacturer's item prices from a table and I type in the number of items for it to be multiplied by. It then gives me a total in the "total" field. The problem is that once in a while I need to change the total of a particular item but when I select the field, it tells me the field is bound to a calculation. Is there any way to allow this total to be edited without changing the manufacturer's price of the item I am trying to total? I need this price to stay the same for future calculations.

 

[dynamictiger]

I think your total field is bound to the table and consequently you cannot change it.

Try making it unbound, you do not need to save the value anyway as it is calculated.

I cannot imagine why you would want to change this value, unless it is for a discount, delivery fee or what have you. This being the case you could add a new field to deal with these instead.

 

[R. Hicks]

You have placed the calculation in the control source of the control that displays the "Total". This is the reason you can not change the value (it's bound to the expression). You need to populate the "Total" by running the calculation when you type in the "number of items" information using the After Update event of that control. This will populate the "Total" ... the control will remain "unbound" and you will then be able to change (override) the result of the calculation.

HTH
RDH