Copy contents of one field to another

[10 Gauge]

I am wondering if this is possible.

I would like to have a button next to a field on my form which when pressed will copy the contents of the field to a different field on the same form/record and set the originating field back to null.

I would also like the field being copied in to to not have any previous data erased and overwritten. I'd just like the data to be added to whats already there.



I am designing a Miss Utility ticket tracking database which needs to be updated frequently, each job gets assigned a new ticket number every time it's updated and I want to store all of the old ticket numbers in a memo field just for reference and safekeeping.

Can something like this be done? TIA.

[NTC]

yes. Assuming your data is in txt1 and you want to add it to txt2; then on that command button you would put:

me.txt2 = me.txt2 & " , " & me.txt1

have put in a comma between which you can leave out if you want to:


me.txt2 = me.txt2 & me.txt1

then below that just put
me.txt1 = ""

to blank that field

hope this helps.

[weekend00]

correct and neat

[10 Gauge]

yes. Assuming your data is in txt1 and you want to add it to txt2; then on that command button you would put:

me.txt2 = me.txt2 & " , " & me.txt1

have put in a comma between which you can leave out if you want to:


me.txt2 = me.txt2 & me.txt1

then below that just put
me.txt1 = ""

to blank that field

hope this helps.

Thank you NTC! Do I just create a new module for this code? I'm sorry I'm just new to all of this but tryind to trudge my way through it and get this project done.

[10 Gauge]

I got it.

Thanks again NTC that's absolutely great!

Instead of a comma, is there a way to add a line break since the data is being input in to a rich text memo box?