View Single Post
Old 07-05-2019, 10:04 PM   #14
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,457
Thanks: 68
Thanked 2,713 Times in 2,598 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
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:

'disconnect it
me.theMemoTextboxName.ControlSource = ""
'open the edit form
docmd.openform FormName:="editFormName, WhereCondition:="ID=" & Me.ID, WindowMode:=acDialog
'reinstate the ControlSource
me.theMemoTextboxName.ControlSource="theOriginalFi eld"
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote