How do I show several records in one field?

[ermcc]

I have a table: Complaint
Within the table there is a field: CustomerID
There could be anywhere from 1 to 10 records with the same CustomerID.
I would like to show all the complaints for a specific CustomerID on a form in one field.

Right now I have the following Control Source Code:
=[Complaint.PartNumber] & ", ," & [Complaint.PNdescrip] & ", ," & [Complaint.Complaint]
This code will only display 1 record.

I would like the text box to look like this: (All from the same CustomerID number)



Part Number A PN Description A Complaint A
Part Number B PN Description B Complaint B

[orange]

Do you have a relationship between your Customer Table and your Complaints table? What is your data base structure?
Can you post a jpg?

You might use Form and subform, but you won't get all records in the "same field".
Maybe the same column???

[ermcc]

I decided to change the format and not go with several records in one field. I am using a combobox and its working.
Thanks for the reply Orange.

Have a great day!!!