control Bound to Field

[kedarj]

In my Textbox Control source I have given a formula =[Product Price]+[Delivery Costs].
I would like to provide an option to ther user to overwrite this Textbox (Should able to input a value).
When I try to edit the calculated value on the form, I get a message "Control cannot be edited, bound to expression". What can I do?

 

[MStef]

Access don't permit you to enter a value because
you have said (in control source) that the value is
Product price + Delivery coast.

 

[kedarj]

what is the alternative?

 

[MStef]

It's up to you, depending what you want with this textbox.

 

[kedarj]

I want to have the value calculated by a formulae with an option to edit it/overwrite it.

 

[Rich]

Use vba to populate the control, you should then be able to overwrite it, not something to be undertaken lightly though

 

[mabl4367]

I think it would be possible to use the calculation as a "Standard value"