Retaining text during a click action

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields set up on a form, when the user double clicks in field 1,
the text that was in Field 1 then moves to field 2. The issue is that the
text in field 2 only retains the most recent text change - overwriting the
text that was in field 2 previously. How do i make it so that every time the
text moves to field 2, that it keeps a running history of the text?
 
field2 had better be a memo type or you will fill it up very quickly. In any
case, you click event code is probably something like:
Me.Field2 = Me.Field1
Make it:
Me.Field2 = Me.Field2 & " " & Me.Field1

I put a space in so there will be a separation
 
Back
Top