>>>I thought for sure I had saved this somewhere, but I can't find it.
>>>
>>>I need to append the contents of a text field on a form to the end of a memo field without losing what is already in the memo field. It is too early and I can't seem to think straight :)
>>>
>>>Basically the user will add some information to the textbox, and then on save it will be added to the end of a running history file.
>>>
>>>thx,
>>
>>Phil
>>
>>Replace memofield with textfield
ADDITIVE>>
>>Terry
>
>I'm doing this on a data entry form. I'm trying to append the contents of thisform.txtUpdate to the end of thisform.edbHistory. I keep getting an error "edbHistory is not a file variable" ??
Ah,
I thought you were appending to an existing memeo field in a table. Presumably, then, thisform.edbHistory is the "screen embodiment" of the memo, presumably in an edit box? When you refer to the contents of controls, you need their .Value, e.g.
thisform.edbHistory.value = thisform.edbHistory.value + thisform.txtUpdate.value
That work?
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.