move text from one field to another automatically

[veder]

Hi, I have a form set up, among other fields in the form is a Weekly update
free form field. I have another field called Historical Weekly updates. What
I want to happen is that when a user clicks in the Weekly updae field, the
text that is in there should pop down to the Historical field and have the
date of the move post next to the text in the historical field. I have no idea if this is a click action, a macro, or if it's even possible.Any help would be greatly appreciated!!


Thanks!!!

 

[BobJones]

How bout making an onclick event for weekly updates and putting something like...

textboxHistoricalfield.Value = textboxWeeklyfield.Value

That any good?

 

[workmad3]

If you want to keep the data, then in the onclick event you would want

textboxHistoricalfield.Value = Date() & ": " & textboxWeeklyfield.Value & vbcrlf & textboxHistoricalfield.Value

Otherwise just
textboxHistoricalfield.Value = Date() & ": " & textboxWeeklyfield.Value

and always in the onclick event.

Oh ,and don't forget the line
textboxWeeklyfield.Value = ""
if you want to clear the textbox afterwards

 

[veder]

How bout making an onclick event for weekly updates and putting something like...

textboxHistoricalfield.Value = textboxWeeklyfield.Value

That any good?

thanks so much! A great help!

 

[veder]

If you want to keep the data, then in the onclick event you would want

textboxHistoricalfield.Value = Date() & ": " & textboxWeeklyfield.Value & vbcrlf & textboxHistoricalfield.Value

Otherwise just
textboxHistoricalfield.Value = Date() & ": " & textboxWeeklyfield.Value

and always in the onclick event.

Oh ,and don't forget the line
textboxWeeklyfield.Value = ""
if you want to clear the textbox afterwards

Thanks so much!! works great now!

 

[veder]

OK - thanks for the help - I am very close now!! - now one final item - how do i make it so that every time the text moves to the historical field, that it keeps a running history of the text? Right now every time I click in the Weekly field, the text moves to the historical field, but it overwrites the move before - so I only ever see one piece of text in the historical field.