After formatting field in query, it no longer accepts edits on the form

[JackieEVSC]

Thanks to some help from this forum, I formatted a field to parse out apostrophe's ... DmgDesc: Replace(Nz([DamageDesc],""),"'",""). It works, but now when the information is pulled into a form, it no longer allows me to edit the field.

We really need this field to be updatable. What would cause this? Any idea how I can fix this?

Thanks in advance.

[davegri]

You can't edit a derived field like that. DmgDesc doesn't exist in the table.
In your form make the data source for your textbox equal to DamageDesc.
In the Form_Current event:
txtDamageDesc = Replace(Nz(txtDamageDesc,""),"'","")

Now you can edit DamageDesc in he form, assuming the textbox holding DamageDesc is named txtDamageDesc.

[JackieEVSC]

Works perfectly! I would never have been able to figure that out on my own! I am VERY grateful for your help!!!!

[davegri]

Glad to help. Good luck with the rest of your project.