• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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