A Dropdown List that lists the queries in the database

D

Danny B

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!
 
G

Graham R Seach

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
Click to expand...
the queries I've made in the database?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help creating a search form in Access XP 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
No option to create a list in SharePoint Site 0
Access Backstage Reset DropDowns 0
Merging from an Excel file with graphics 1
Duplicate hashtags in OneNote 0
Weekly Report 2
Drop down lists in seperate columns 5

Top