• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

Get a list of all reports to populate a combo box

I need to populate a combo box with all reports in my Access application.
How can I do that?
With a query (somehow) or through VBA.
Any help please.
0
Fritz Paul
Asked:
Fritz Paul
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use the MSysObjects table:

SELECT [Name] From MSysObjects WHERE [Type]=-32764
0
 
MINDSUPERBCommented:
You need to put query string given by LSM on the Row Source of the Combo Box.

Ed

0
 
Fritz PaulAuthor Commented:
Although someone improved on it, it was actually 100% for me.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now