Retaining text during a click action

T

tiffer

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?
 
K

Klatuu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top