Although this isn't the same topic that this thread started with, it may offer some insight into Containers and Documents discussed/discovered in the thread. After looking at the M$oft material on Container and Document, the attached is a sample of Containers and Documents in my test database. This is a modification of an example.
Code:
' ----------------------------------------------------------------
' Procedure Name: ContainerPropertyX
' Purpose: Display the Container names and the name of each
' Document in the Container's Documents Collection
' in the current database
' **Note: Not all Containers have documents
' Procedure Kind: Sub
' Procedure Access: Public
' Author: Jack /based on M$oft Example
' https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/document-container-property-dao
' Date: 19-Mar-23
' ----------------------------------------------------------------
Sub ContainerPropertyX()
Dim dbs As Database
Dim ctrLoop As Container
Dim doc As Object
10 Set dbs = CurrentDb
20 Debug.Print "Containers and Documents in " & CurrentProject.Name & vbCrLf
30 For Each ctrLoop In dbs.Containers
40 Debug.Print "Container Name: " & ctrLoop.Name
50 On Error Resume Next
60 For Each doc In ctrLoop.Documents
70 Debug.Print ".... " & "DocumentName: " & doc.Name
80 Next doc
90 Next ctrLoop
100 dbs.Close
End Sub
This is the output from the test database .
Containers and Documents in NoComm2.accdb
Container Name: DataAccessPages
Container Name: Databases
.... DocumentName: MSysDb
.... DocumentName: SummaryInfo
.... DocumentName: UserDefined
Container Name: Forms
Container Name: Modules
.... DocumentName: basStripComments
.... DocumentName: ModAjax
.... DocumentName: ModAjax2
.... DocumentName: ModAjax3
.... DocumentName: ModDaveGri ..............<<I did create a module and try Dave's code
.... DocumentName: ModFromMyOKDB
.... DocumentName: ModMSoftContainerEtc
.... DocumentName: ModuleTest
.... DocumentName: ModVlad
.... DocumentName: MYWorkONA97
Container Name: Relationships
.... DocumentName: MSysNavPaneGroupCategoriesMSysNavPaneGroups
.... DocumentName: MSysNavPaneGroupsMSysNavPaneGroupToObjects
Container Name: Reports
Container Name: Scripts
Container Name: SysRel
Container Name: Tables
.... DocumentName: MSysAccessStorage
.... DocumentName: MSysACEs
.... DocumentName: MSysComplexColumns
.... DocumentName: MSysNameMap
.... DocumentName: MSysNavPaneGroupCategories
.... DocumentName: MSysNavPaneGroups
.... DocumentName: MSysNavPaneGroupToObjects
.... DocumentName: MSysNavPaneObjectIDs
.... DocumentName: MSysObjects
.... DocumentName: MSysQueries
.... DocumentName: MSysRelationships
.... DocumentName: MSysResources
.... DocumentName: TemplateForUSysRegInfo