get data from multiple rows into 1 textbox

Hi, I'm using this code to get data from multiple rows with the same criteria into 1 textbox, but what it is doing is only taking the last row of that criteria and putting it into the textbox. how do I change it so that the correct number of rows of data is reflected in the textbox?

Please Login or Register  to view this content.

hi norie, It is textbox18.

Please Login or Register  to view this content.

I would like to have "Sample / Type / Marking / Mortuary / Date & Time Received" as a header, then line break, followed by the data. So, it should look something like this:

Sample / Type / Marking / Mortuary / Date & Time Received
Sample1-001 hair 12345 M23456 12/10/16 11.15am
Sample1-002 tooth 33445 M34543 12/10/16 11.15am

hope that explains it

How do I make the scrollbars on the textbox appear when I need them to? the info exceeds the size of the textbox, and even though I set scrollbars to both, it doesn't appear