Iterate Forms and Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I would like to list all Forms and Reports that are not Hidden. I going to add them to a listbox. I just need to know how to get to the collection that stores the Visible forms for access

Thank you

Brandon
 
Hi:

Application.Forms stores the Visible (or Open) forms.

Otherwise use CurrentDb.Containers and check out help on Containers to
access all forms and report objects.

Regards,

Naresh Nichani
Microsoft Access MVP

Brandon said:
Hi,

I would like to list all Forms and Reports that are not Hidden. I going to
Click to expand...
add them to a listbox. I just need to know how to get to the collection that
stores the Visible forms for access.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mulitple instances of a report 2
VBA: How can I get the type of the control programatically? 9
Filll listbox with the Caption of all the reports in a database 4
Report displaying behind form 7
Filter report with Combobox AND Multiselect Listbox 2
Iterating subform on Load/Open gives error 1
2 list box iteration 1
Form set the Visibility of a Label in a Report? 6

Back
Top