bound = calculated

[wshm]

Me.txtTranxAmt = Me.txtActualAmt / Me.txtActProd
Me.txtTranxAmt.Requery
Me!txtGhost = Me!txtTranxAmt

txtGhost is bound and txtTranxAmt is calculated

how come it says you can't assign that value to this object?

 

[Zion7]

Well, if you're corrcet in saying that txtTranxAmt , is
calculated, then why are you trying to assign a value to it?
Me.txtTranxAmt = Me.txtActualAmt / Me.txtActProd??

Calculated means the contol source of the field,
has a predifened value.
Is that the case with Me.txtTranxAmt?
just because you make a calculation for it, via VBA,
doesn't mean it's calculated BUT,
the error message seems to imply you have an expression,
in the control source of Me.txtTranxAmt ?

either assign a value to it Via VBA or,
in the controlSource of the control put,
=Val([txtActualAmt] / [txtActProd])

 

[wshm]

well calculated value must be stored in the table...

 

[Zion7]

allow me to digress a bit,
elementary rule about databases design, never store
derived data!

Calculated value must not be stored in table.
Use calculated control, as described above,
or computed field in a query.

But, problem remains, you error message is implying you
have an uneditable field, why, do you.

If all your fields are bound, then the control source should be identical to the name.

is this the case?

 

[wshm]

i used query =)
thx