Please Help: Append New text to old text

[sam]

Hi All,

I have a form which populates access database.

On the form Once we input a student Id, we can input student records and
also add comments, after making the changes we click "Submit" and the data
goes in the databae.
One field that I have on the form is "Comments" Textbox whereTA can insert
their comments for any student.
Here multiple TA's can comment for one student. The issue I want to resolve
is. When a new TA inserts a comment, Old comments are deleted and replaced by
the new comments. Is there a way to append new comments to old comments and
not delete the previous comments made by other TA's?

Hope I made it clear.

Thanks in advance

 

[John W. Vinson]

Hi All,

I have a form which populates access database.

On the form Once we input a student Id, we can input student records and
also add comments, after making the changes we click "Submit" and the data
goes in the databae.
One field that I have on the form is "Comments" Textbox whereTA can insert
their comments for any student.
Here multiple TA's can comment for one student. The issue I want to resolve
is. When a new TA inserts a comment, Old comments are deleted and replaced by
the new comments. Is there a way to append new comments to old comments and
not delete the previous comments made by other TA's?

Hope I made it clear.

Thanks in advance

I would pretty strongly suggest that you change your table design to
accommodate this need, rather than jamming a lot of unrelated comments into a
single Memo type field. Consider a Comments table with fields CommentID
(autonumber primary key), StudentID (a link to the students table),
CommentDate (date/time, default value =Now() to capture the date and time that
the comment was entered), TAID (to record who made the comment), and Comment
(the memo field for the actual comment). This can be displayed on a Subform;
it will let the TA identify themselves by selecting their name from a combo
box, enter the comment, and have it automatically timestamped and linked to
the student data.