Overwriting Calculated Field

[sidewayzalex]

Hey again,


I am having trouble with a Bill of Materials form.
I would like to take some fields and display the subtotals/totals of the cost price (what we buy the part for) and the sell price (what we sell for).
The thing is, we often get orders that are slightly under our lower limit of cost, and they need to be pushed up a few dollars to fit the lower limit. We also give discounts to certain types of customers. Knowing this, I would like to have a generalized subtotal and total field for Extended cost and Extended Sell.

The total is suppose to add together the labor costs and the subtotal, and this is the particular field that I wish to overwrite.

As of right now, I am using text boxes with equations referencing the several subforms within this form to get the calculations.

Is there a way to have the default value be the calculation, and be able to change it if necessary, without changing permanent data?

Thanks ahead of time.

[June7]

Don't understand. Why would you want to overwrite a calculated value with a value that does not derive from the stored data?

A default value can be an expression but if values aren't already available when the new record is created, the default will calculate null. The DefaultValue property only applies when record initially created.

[sidewayzalex]

The option that we have come up with is an adjust price field that can either add or subtract to the total and give us a grand total.

To the best of my knowledge, the only reason to overwrite the calculated value is if the price is under the credit card minimum limit for sales (or something like that). Believe me, I dont fully understand why either, just trying to do what my boss asks.
Thanks though