Adding to existing data.

[PuddinPie]

I know there is a way of doing this because I've come accross it before but now that I need it I just cant find it.

I have a table with a column called "Comments" I want the user to be able to type something into a form and upon clicking the 'add comment' button it will add to pre-existing comments in a type memo field in the table based on a trouble ticket number.

If someone could give me a push in the right direction, that would be nice.

Thank you.

 

[boblarson]

If the memo field is included in the form's record source you can add to that memo field by using this in the button's click event:

Me!YourMemoFieldNameHere = Me!YourMemoFieldNameHere & Me.YourTextBoxNameHere

But you might want to put the new comments in front of the old and then a separator so you could use:

Me!YourMemoFieldNameHere = Me.YourTextBoxNameHere & vbCrLf & "___________" & vbCrLf & Me!YourMemoFieldNameHere

That way the latest comments are on top.

 

[PuddinPie]

Thank you. That work perfectly. You rock.