Populate multiple records from subreport to text box

[dbar10]

I am building a report for clinical info on client. I have a subreport that has the records of multiple medications, dosages,frequency and routes. I need these results to print in a text string format in one box on the main report called [HCFA 485]. I can't get my head around this. I wrote the line below to show the fields I'm dealing with and this will show the first record but I need all of them.

=[POCMed Table Query subreport].Report!Meds & ", " & [POCMed Table Query subreport].Report!Dose & ", " & [POCMed Table Query subreport].Report!Frequency & ", " & [POCMed Table Query subreport].Report!Route

Occasionally, one record may wrap to a new line in the box and I need the next record to start a new line in the same box. I hope that you can help. Thanks

 

[dhookom]

It isn't clear what you want. A wag is that you want to list information from multiple child records into a single text box on your main report. Try faq701-4233.

Duane
Hook'D on Access
MS Access MVP

 

[dbar10]

Thanks dhookom. I will work with this. Appreciate your work.