Listing all created Queries

[Guest]

Although I am proficient in SQL and running queries in Access, I am new to
database creation. One requirement is to have a switchboard button that
takes me to a Queries form that is combo box of all the queries I have
created for the user to select based on requirements. How do I go about
creating a table that this combo box references so that the user can select a
query to be executed? I have 20 queries available that the user can run from
a Forms Switchboard, but I do not know how to get these queries into one
location for the user to select.

Thanks.

 

[Allen Browne]

Try this in the RowSource of the combo:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "~*") AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;