Runtime Error 2448 - Cannot assign value to this object!

[Guest]

I have an MS Access form attached to a table. I have a text box which
has its control source set to a field in the table...
However, at run time if certain things change, I want to the change the

text box value to the new number, but I'm unable to do so. I get run
time error 2448, you cannot assign value to this object..

The text box is attached to a currency field and all what I'm doing in
VBA is: -


Me.txtTotalPrice.Value = 0


This generates an error.. Why?

 

[Allen Browne]

In what event are you doing this?
It could be that the timing in not appropriate.

Perhaps the example you gave is a simplified one, but you should be aware
that storing a total is unnecessary and unnormalized. If you're not sure
what that means, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html