Is there an easy way to find dependencies for a subform in Access?

Question

For a given form in a database, is there a quick/easy way to find all other forms in an Access database use it as a subform?

Note: I am only concerned with main forms that have it defined using the property sheet, it is easy enough to do a code search for any form that dynamically sets it as a subform at runtime.

Answer 1

It is not too difficult to use VBA to check.

sfrmname="FormToFind"
For Each frm In CurrentProject.AllForms
   DoCmd.OpenForm frm.Name, acDesign
   For Each ctl In Forms(frm.Name).Controls
      If ctl.ControlType=acSubForm Then
         If ctl.SourceObject = sfrmname Then
            Debug.Print frm.Name
         End If
      End If
   Next
   DoCmd.Close acForm, frm.Name
Next

Or there abouts.

Answer 2

Right-click on the form in the database window and select "Object Dependencies" This should give you the list of forms that host it as a sub-form.