Combo Box that retirieve queries or reports

L

lordjeffj

Hello,

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

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
 
Top