Cut and Paste several fields into one field

[Shaun Edwards via AccessMonster.com]

I have the following fields in a page used to monitor progress on students:
Status Tutor (textbox), Comments Tutor(textbox), Status Mentor (memo),
Comments Mentor (memo), Action (memo), Achieved Action Date (date). Within
this form I have a link to a notes page. What I would like is for the field
labels, along with the field values for the above mentioned to be cut &
pasted to my notes section once an action achieved date has been entered.
But, this will be an on-going process, therefore it must paste to the last
point of entry in my notes (memo) field. Any help would be very much
appreciated.

 

[JohnFol]

This sounds like you are building up a history of status / tutors and
comments all realting to the progress of a student. You will need to keep
these in a separate table, and onyl brign them together for display in the
form / report.

 

[Al Camp]

Shaun,
Hmmm... not sure what you're doing here... but...

If you're saying that every once in a while... according to some
condition, you will take the label caption and field values from several
fields and Append then to a memo Notes field?
OK.. then
On your trigger event....
[MemoNotes] = [MemoNotes] & lblStatusTutor.caption & ":" & [StatusTutor] & "
" & lblCommentsTutor.Caption & ":" & [CommentsTutor]... etc etc for all
labels and fields

hth
Al Camp