Joinin the items on an order (Joining strings???)

[axess_nab]

Hi guys! I continue working on my db the first stage is almost completely done I still have to configure some reports and try to implement a code to take a number and write it with words and try to use the db on a local LAN

There's still a long way to go I can implement: manage inventory, include warehouse movements and invoices and I may be asking for more help

I've been reading about joining strings and I have been able to use it to different text fields like: [FirstName] & " " & [LastName]



However I would like to know if I can use it to join the content of a subform that I use as a datasheet. In simple words I want to join the items on the purchase order I have programmed. The items go inside a the subform "Pedidos" the fields I want to join are the Quantity and the Description of every record inside the subform to put it on a field in another form. Is that possible? (I really hope I made myself clear)

I've been having problems with the syntax of strings like in the use of dlookup and more recently in opening a form with an especific record that is determined by a field containing a string value so If anyone has some advice I will appreciate it cause I kinda suspect I'll be having more problems when trying to join the strings I want to.

Thanks!

[orange]

I'm sure just about anything is possible. Mostly just SMOP (small matter of programming). However, the question I think, all readers want answered is "Why"? If you have these fields on a subform, why concatenate values and put the on another form?

If you need them in another location, why not include them in the record source of the report/form or whatever?

[axess_nab]

orange hey I definitely understand your observation the thing is that after a "purchase order" is made we have to make a "payment order". This is made by a format with just a small field were we describe what we are asking to be payed in this case we normally write again everything we asked for in the purchase order. As you can imagine this takes time and I will like to do this automatically and since we have to be able to print it to be signed and we require two copies we have been using a half page sized format and the space... well I would rather not put a table again containing every item of the purchase order for space sake.