Add contents of one field to another (for a notes system)

R

RitchieJHicks

I am attempting to set up a notes system.

I have a memo field called "notes" (locked) and another memo field called
"notessubmit" in my table. I wish to have a button on my form which when
clicked, will add the text from the "notessubmit" field to the text already
in field "notes".

Can anyone advise me on this (N.B. my coding knowledge is minimal).

Thanks,
Ritchie.
 
S

smk23

Private sub cmdButton_onclick()
Dim strNotes as string

strNotes=Me.Notes

Me.Notes=strNotes & Me.Notessubmit

End Sub

This is very bare bones. I.e. nothing here to put in a space or new line
between the notes. Also, do you want the new note at the beginning or end of
the previous notes, etc.
Sam
 
R

RitchieJHicks

Hi Sam,

That's great. I think I understand. How would one set this so that it was at
the beginning of the exisiting note AND had a line-space inbetween the new
and existing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top