fetch data from table and show in text box

[prithwisaha]

Hi All,

Need to fetch data from table in group and show them in a single text box. Attached image for your reference.


Please kindly help:

[ranman256]

all the data is shown in a grid with zero effort by simply using a form...(single record or continuous form)
why do you want code to chop up the record into a single box?

[prithwisaha]

It needs grouping. Whatever data is shown in the text box will be send as SMS. A combo will be there to select the date. A command button will be there to show the data in the text box with grouping. That data will be send to users in SMS.

[Minty]

Use Allen Brownes Concatenate function from here;
http://allenbrowne.com/func-concat.html