How do you display objects in a collection

[PatSalmon]

I am getting the following message: "could not find the object in the collection corresponding to the name or ordinal". How do I see what objects I have in a collection?

Thanks
Pat

 

[cmmrfrds]

Of course, it depends on what collection you are using.

Here is the general format with an example of the Users and Groups collections.

Dim cg As New ADOX.Catalog
Set cg.ActiveConnection = CurrentProject.Connection

Dim ur As User, gp As Group
For Each ur In cg.Users
Debug.Print "Users = "; ur.Name

For Each gp In ur.Groups
Debug.Print " Group = "; gp.Name

Next
Next

 

[SBendBuckeye]

Here's another example for Controls on a form:

Dim cntl As Control

For Each cntl In Me.Controls
Debug.Print cntl.name
Next cntl

If you browse the me object in view locals debug pane, you will find other things you may want to see.

Good Luck!