Copy value of several records to one record 1

[MikeCDPQ]

I have posted this problem before but the solution didn't work. Maybe I didn't express myself clearly enough.

I want to copy the values of 1 field from all records to one memo field on another form.

Basically I need to loop throuh all records, grab the value of each and paste them one after the other in the memo field of the other form, each seperated by a line feed.

Ex:
control Name in form 1
record 1 = Smith
record 2 = Johnson
record 3 = Brown


Control Name in form 2

record 1 = Smith
Johnson
Brown


I have my looping routine but then I cannot have forms!form2!Name = Forms!form1.Name because it overwrites what was already there. I need to copy & paste but haven't come up with a decent solution yet.

Any help will be very appreciated.

Thanks.

Mike

 

[PHV]

I have my looping routine
Any chance you could post your actual code ?
Tip: Forms!form2!Name = Forms!form2!Name & RecordValue & vbCrLf

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MikeCDPQ]

Hi PHV,

There is no need for me to post my code. You tip worked like a charm. That's exactly what I needed.

You're the best.

Thanks a million.

Mike