Subreport Question

Question

I have another one that should be easy, but is driving me crazy!  I have spent all day on it to no avail.  Perhaps you all can save me time and relieve my frustration.

I have a access 2013 db.  There are two tables, RecordsParent and RecordsChild.  There is a relationship between the two tables on a field named ID.  This relationship works fine on a parent form with a child subform.

I also have a report that shows the parent information fine.  I added a subreport that is supposed to display the child information.  When I run the report, it shows the parent record, but the subform does not appear.  When I run the subreport by itself, it shows the records I expect.  However on the report, only the caption of the subreport shows.  Any ideas?

I would be glad to share a db with this stuff in it!

Answer 1

Have you set the Link Master Fields and Link Child Fields properties of the subreport on the main report to ID?

(If you can upload and share a copy of the workbook to OneDrive, DropBox or Google Drive, that would help)

---

Regards, Hans Vogelaar (http://www.eileenslounge.com)

Answer 2

Hans,

Thanks as usual for your response.  Yes, the fields properties were set correctly.

Well color me embarrassed, my attempted technique was a waste of time.  For some reason, I got it in my head that I needed a report/subreport to do this.  I made it more difficult than was needed.  All I needed was the parent information in the report header, and the child information in the detail.  I should have heeded the KISS principle.