ListBox into Text List

[Hey_Moe!]

This should be simple, but it's really bugging me.

I have a form that is used as a front end to an e-mail generator.
The forms contains several text boxes and one list box.
There's no problem getting the texts boxes to appear in the generated e-mail
message, but the list box is another thing.

If a row of the list box is selected prior to hitting the 'Generate Message'
button, only then does that row appear in the message.
Is there a way of getting all the rows of the list box to appear in the
generated message without the need to select any of the rows.
(I've tried having a hidden text box that contains what is in the list box,
but the same problem arises. ie. If no row is selected than no data
appears.)

Thanks.

 

[Arvin Meyer]

Check out the code in this sample database:

http://www.datastrat.com/Download/EmailSenate2K.zip

It does require that you use the list box, but it works 100% of the time.
You can select contiguous records, so you don't need to click each one. BTW,
don't actually send the emails. Many of them bounce and it irks your ISP.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access