How to tell if a report uses sub reports? 1

[egstatus]

Is there a way to find out if a report uses sub reports?
I have a sub report that I modified but I need to know what reports use it. [Without having to open each report in the reports object]

I was thinking that there may be a way to iterate through each report and print its children (report names), but I'm not a ware if there is a way.

Thanks

Ed

 

[PWise]

take a look @ object dependencies

 

[MajP]

Object dependencies may work, but I found on a really big application you will get too much additional information.
mdbdoc provides a ton of this type of information but not exactly what you are looking for.

http://mdbdoc.sourceforge.net/

This code will print out the answer showing where all subreports are used.

Public Sub WhereUsed()
  Dim rptObj As Access.AccessObject
  Dim rpt As Access.Report
  Dim ctl As Access.Control
 
  For Each rptObj In CurrentProject.AllReports
    DoCmd.OpenReport rptObj.Name, acViewDesign
    Set rpt = Reports(rptObj.Name)
      For Each ctl In rpt
       
        If ctl.ControlType = acSubform Then
          Debug.Print ctl.SourceObject; " is used by " & rpt.Name
        End If
        Next ctl
      DoCmd.Close acReport, rptObj.Name
    Next rptObj
        
End Sub

 

[egstatus]

Awesome.

Thank you.