Edit or Change in Calculated field

[jaytejani]

Hello friends,
i have a sub form where five numeric field, assumed that field name are A, B, C, D, E, Where D and E are Calculated field like as like this D= B*C, AND E=A*D
MY quotation is, Can i change/Edit value of field D ??
When i edit/change value, of D, Field B AND C will remain empty.

 

[plog]

Can i change/Edit value of field D?

No, you just said its calculated.

 

[missinglinq]

Well, not directly, as plog said! Only by changing the Values of B and/or C...and maybe (depending on where you're doing this) by using Me.ReCalc.

Linq ;0)>

 

[boerbende]

If I understand you correctly:
You want to have a calculation D = B * C, but you want to be able to overwrite the calculation as well. I would do this with the afterupdate events of B and C

Private Sub C_AfterUpdate()
me.D = me.C * me.B
End Sub

etc...

When you have linked D to a control source in your table, you still can change the results, even though it is "calculated"