Cut and Paste several fields into one field

  • Thread starter Thread starter Shaun Edwards via AccessMonster.com
  • Start date Start date
S

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.
 
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.
 
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
 
Back
Top