memo field (1 Viewer)

[jerry28ph]

I have a memo field on my form and im using this field to store information about the customer order status. How can I add new information with the username and date attach at the end without overwriting the old information after i click the "Save" button. I dont want to go directly to the memo field and enter the messae coz I have some field value to add on it.

ex:

customer called to follow up order status. <jerry><5-13-2009>

received email from this customer <john><5-14-2009>

Please help.
Thanks

Jerry





I want to use another field name

 

[HiTechCoach]

You can add text to a control on a form using something like:

Me.txtMyMemo = Me.txtMyMemo & vbCRLF & "customer called to follow up order status. <jerry><5-13-2009>"


I would recommend not using a memo field, but a separate table where a new record is create for each comment. Use separate field for the data/time, user, comment, contact type, etc.

 

[jerry28ph]

Thank so much.. it works.
More power HiTechCoach

You can add text to a control on a form using something like:

Me.txtMyMemo = Me.txtMyMemo & vbCRLF & customer called to follow up order status. <jerry><5-13-2009>


I would recommend not using a memo field, but a separate table where a new record is create for each comment. Use separate field for the data/time, user, comment, contact type, etc.

 

[HiTechCoach]

You're welcome!

Glad we could assist.