dear All
can i copy all records from column in table in sub-form to a text box in main form
regards
dear All
can i copy all records from column in table in sub-form to a text box in main form
regards
That makes no sense. What exactly do you want to accomplish? What purpose would this serve?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
to copy all names in textbox and send a message for them
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.