Have date inserted in memo field on update

[Amy35]

I have a trouble ticket form where the user inputs the problem description. That is the only field they can alter.
Here's what I'd like to do. When the user goes to *add* to a ticket that they had previously submitted, I would like the date it was added to be inserted before their comment.
I have a ticket date field on the form and was thinking I could check to see if that was less than today and if it was then insert the current date before the comment.

So the field would look like this for a ticket that was submitted yesterday but updated today

Can't logon to the LAN 5/14/02 problem has been fixed please disregard

I got the idea just having trouble with the code and where to put it. Thanks for any help.

Amy

 

[Ally]

This may be what you want:

On DoubleClick Event of your memo field add:

NameOfField.Text = Date & ": " & vbCrLf & NameOfField.Text
NameOfField.SelStart = Len(Date)

 

[Amy35]

Thanks, that worked great!