Concurrent or Multiple Date postings

[MitchR]

Hello to All; I have inherited a database and need to have the database post a date in a comments column which I can do. Problem is every time I execute the event procedure it replaces the old date with the new date. I am trying to figure out how to keep the old date and place the new date as well. Here is my code below:

 
Dim myDate As Variant
myDate = Date
[Forms]![Daily_Terms]![comments] = "Date of Notification From Mitch " & myDate & "; " 

The above code places my date in the comments text boxt but replaces it upon each execution. My Question is ... how would I script the process of leaving the old date of execution and placing the date after it ?

[NeoPa]

You say you want to update it - but you don't really explain what the 'it' is.
Can you make your question a little clearer?
It doesn't sound too complicated, except for lack of information.

[MitchR]

I appologize; What I am trying to accomplish is to have the date stamp process, insert another entry into my textbox and leave the old date stamp as opposed to replacing the old date stamp. For Example: This is what I want to accomplish within the Comments textbox:

Date of Notification From Mitch 12-4-06; Date of Notification From Mitch 12-5-06; Date of Notification From Mitch 12-6-06;

As is the date stamp would overwrite the previous date stamp, and place the new date stamp in the old date stamp's place.

[NeoPa]

My bad MitchR.
I've just seen what I missed before (snow blindness obviously ;) ).
The code you need is :

[Forms]![Daily_Terms].[comments] = [Forms]![Daily_Terms].[comments] & _
                                   "Date of Notification From Mitch " & _
                                   Format(myDate,"d mmm yyyy") & "; "

If the code is running from within the form's module though, you can replace ([Forms]![Daily_Terms].) with (Me.).
This is better because it is more succinct and also because it is more efficient to process.

[MitchR]

Thank You !!!!! Thank you!!!! That is Awesome !!!!

[NeoPa]

My pleasure MitchR.
Sorry for the confusion.