Combo Box that retirieve queries or reports

[lordjeffj]

Hello,

Could someone tell me how I can list the queries of an access database in a
combo box in my access form?

 

[Nikos Yannacopoulos]

You need to set the RowSOurce property of the combo box to:

SELECT Name FROM MSysObjects WHERE Type = 5 AND Name Not Like "~sq*"

for queries, or:

SELECT Name FROM MSysObjects WHERE Type = -32764

for reports.

HTH,
Nikos