Add text to memo field without overwriting existing text

[mhall]

I have a form that contains several fields with pick list and a memo field. When a selection is made from one of the combo boxs text is entered into the memo field. The only problem is that this field could already have text entered.
How can I add the text to a new line in the memo field using code.

 

[raskew]

Say your combo box is Combo6 and your memofield = "thememo", this code in the AfterUpdate event of Combo6 should give you what you're after:

Private Sub Combo6_AfterUpdate()
Me![thememo] = RTrim(Me![thememo]) & Chr(13) & Chr(10) & Me![Combo6]
End Sub