Re: Can't assign Value to this object
if you are opening another form to edit the memo while it is open in another form, you may try to disconnect it first to the first form, open the edit form in acDialog window mode. after edit is done, reinstate the control source of the memo, ie:
me.theMemoTextboxName.ControlSource = ""
'open the edit form
docmd.openform FormName:="editFormName, WhereCondition:="ID=" & Me.ID, WindowMode:=acDialog
'reinstate the ControlSource
"Never stop learning, because life never stops teaching"