Sum / Summary Tel Numbers In Comma Seperated Text Box...

[on-2]

Ok heres one im stuggling with...

I am using a sms service and trying to mass sms the mobile numbers i have stored in a table. Only problem is the sms code understands to look in a particular text box on a form for the numbers each seperated by a comma. i.e. 07979 797979, 07979 079797, etc, etc

I can copy these in by hand of course but what i would like to do is utilise a subform i have on a main form. This sub filters down to the customers i want to send to and displays the client and mob line by line all this is fine but i cant think how to populate this text box.

I was thinking about some kind of Forms!etc!textbox & ", " & etc combination maybe with some use of the sum but i am struggling. Anyone got any ideas

 

[Uncle Gizmo]

So are you saying that the telephone numbers are listed in a telephone number field and display as a list in a sub form? If that is so, now you want the telephone numbers to be displayed as it were "horizontally" in a single text box? 07979 797979, 07979 079797, etc, etc