Issue with MEMO Field

[editolis]

Hi all,

I have a simple form with a client name and some notes. (The field is memo)

I have also a button called “Case complete”

I need your help.

When I press the button “Case complete” then automatically have that statement in to the notes.

The problem is how can I do this when I have already some other notes for that client?

Because if I press the button then I will loose the previous notes.

I Want to find a solution so to insert the “Case complete” after the previous notes.

Thank you in advance for your help.

 

[HiTechCoach]

It is possible to do without ldestroy9ng the orignal data.

Assuming the textbox control is named: txtNotes

Me.txtNotes = Me.txtNotes & vbCRLF & "Case complete"

I would normally not do this. I find it better to have a separate record for each note with fields for date/time and the note (meno), and the user. This way the notes can be logged in date/time order.

I would also use a status field for this and not physically add it to the notes. You can add this as as the data prints when needed.

 

[editolis]

Thank you for your help HiTechCoach.

Finally i use this: Me.txtNotes = Me.txtNotes & " " & "Case complete"

CASE COMPLETE...

 

[HiTechCoach]

You're welcome!

Glad to assist.