Combo Box that retirieve queries or reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Could someone tell me how I can list the queries of an access database in a
combo box in my access form?
 
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
 
Back
Top