Overwrite expression-based value in a control

[CW]

I have a Materials_Crates form on which we calculate the costs of packing
items for shipment, and arrive at a total cost.
That total materials cost is then displayed in a control on the Quotes form,
using this expression:
This works fine but sometimes the user needs to over-write that cost. This
is not possible and the following message is displayed:
Control can't be edited; it's bound to the expression
=[Forms]![Main]![Materials_Crates].[Form]![Text200]
The control properties include Enabled=Yes and Locked =No.
How can I make this control editable?
Many thanks
CW

 

[CW]

Dave -
Perfect solution, and so easy (as always, once you know!)
Many thanks
CW

Instead of binding the control to the expression, make the expression the
Default Value of the control. Then it will present the value, but you will
be able to edit it.
--
Dave Hargis, Microsoft Access MVP

I have a Materials_Crates form on which we calculate the costs of packing
items for shipment, and arrive at a total cost.
That total materials cost is then displayed in a control on the Quotes form,
using this expression:
This works fine but sometimes the user needs to over-write that cost. This
is not possible and the following message is displayed:
Control can't be edited; it's bound to the expression
=[Forms]![Main]![Materials_Crates].[Form]![Text200]
The control properties include Enabled=Yes and Locked =No.
How can I make this control editable?
Many thanks
CW