copy records to textbox

[hemaazez]

dear All
can i copy all records from column in table in sub-form to a text box in main form
regards

[June7]

That makes no sense. What exactly do you want to accomplish? What purpose would this serve?

[hemaazez]

to copy all names in textbox and send a message for them

[June7]

Copying a string of names to a textbox does not facilitate sending messages. If you want to send message to each person in the subform records, there is no need to write a string of names into textbox. Just cycle through the form's recordset and either build multi-address string for a bulk emailing, or send an individual email to each address. Many examples of this available. Search forum and Google.