Multiple record text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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,
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?
 
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().
 
Back
Top