A Dropdown List that lists the queries in the database

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

Guest

Hi, I've been searching the help directory but to no avail...

Is there a way I can easily create a dropdown list in a form that shows the queries I've made in the database?

Any help is greatly appreciated!
 
Danny,

Enter the following into the combo's RowSource property:
SELECT [Name] FROM MSysObjects WHERE [Type] = 5 AND Flags = 0

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html


Danny B said:
Hi, I've been searching the help directory but to no avail...

Is there a way I can easily create a dropdown list in a form that shows
the queries I've made in the database?
 
Back
Top