Taking values from rows in subform to a textbox in a mainform?

[leonhuynh2006]

Dear all pro and bro,



Please help me out this situation:

I have a subform named "tbl_Sending" and a mainform "tbl_Customer". The data in the subform is varied by the condition in the mainform. Suppose that the subform is satisfied a given condition and it list 3 rows of data including 3 different dates (row1: 1/11/01, row2: 15/11/01, row3: 30/11/01). How could I take these 3 dates into a textbox named "txt_deliver" in the mainform following this format: date1, date2, date3 (It should be: 1/11/01, 15/11/01, 30/11/01).

Forgive for my English.

I am very appreciated for considering and helping,

Thanks

[RuralGuy]

See if this link helps, remembering that your SubForm has a RecordSource that you can access. http://allenbrowne.com/func-concat.html

[leonhuynh2006]

Thanks, but you have another way around? I just know the simple VBA....

[RuralGuy]

Not really, sorry.