Continuous form combining texts in one text box issue

[shree]

HI all,

I am creating one data base for office purpose it is for maintain portfolio,

for which i have created one form this is continuous form in this form in detail section i have made tow text boxes which are showing values first is showing Broker Name and second is BAL for shares value it is showing multi times for each "broker name" right it should...



what i want, i want all broker name and those value in BAL text box it should come in one text box that i will refer as " comment"

BROKER NAME BAL COMMENT

GSAM 20000 ( GSAM 20000 PIMCO 10000 -I WANT THIS COMMENT IN ONE TEXT BOX)

PIMCO 10000


i wanna concatenate those text box's value in one text box is is possible please reply on same


THANKS FOR YOUR HARD WORK ON THIS AND HELP


SHREE

[June7]

You should not save this into table. It is really bad practice and difficult to accomplish. Instead, concatenate the data 'on-the-fly' when needed and present it on a report. Regardless of your decision, VBA will be required. Review http://allenbrowne.com/func-concat.html