Multiple record text box

[Guest]

I have a query that returns all CustomerID that ordered a specific ProductID.
I want to make a form that shows all of the CustomerID's seperated by a ";"
in a single text box. I have found examples that put multiple fields in a
text box, but not multiple records from 1 field. Thanks.

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm


You will need to be comfortable with VBA to code to achieve this.

 

[Guest]

Allen,
Thanks for the info. I played with the code and have a question about it.
The code as written pulls Quantity from the table Order Details. How can I
make this function work if my Quantity resides in the field of a datasheet
created by a query called Order Details?

 

[Allen Browne]

If the field you wish to concatenate is not in the [Order Details] table,
but is in a related table that shows up as a subdatasheet of the [Order
Details] table:
- Create a query that has both tables
- Use that query name as the first argument for fConcatChild().