Load a list box with all reports within DB

[Sully38]

I am looking to add a List box to a form that will allow the user to view any report contained within the DB. I want to make sure I am doing this correctly:

1. Is a List box the correct tool to use

2. Is the best way to pull the reports to use a query off SysObject module?

3. I am starting to get into this development stuff, its just very hard and frustrating not having another person to bounce ideas off, so I guess the fine folks at Mr. Excel are now working on the other side of my cube....Hello Neighbor!!

 

[Sully38]

here is what I just came up with and it seems to work: on the
Form load prop
For Each accObject In CurrentProject.AllForms
Me.cobForms.AddItem accObject.Name
Next

Then I added a view report button and told it to
view me.cobreports

This is working but I want to make sure that there isn't a better mouse trap.

 

[Sully38]

Extra question...

I tried using the same code as above to allow the user to open specific forms, and while it works generally it won't allow to open any forms in DataSheet View, is there a trick to that?

Code to get Combo Box Loaded:
For Each accObject In CurrentProject.AllForms
Me.cobForms.AddItem accObject.Name
Next

Code to behind Button to View form:
stFormName = Me.cobForms
DoCmd.OpenForm stFormName

BTW.. It seems that Combo Boxes work better than List boxes for this.