Select Queries to appear in listbox

[SeRene]

Hi, I need to list all the queries which i want to see on
a listbox. How can i do it?
I only have codes which allow me to display ALL the
queries found in my database.

Here is 1 of them... Row Source ---> SELECT
MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name
Not Like
"~sq*" AND MSysObjects.Type=5

Can some1 tell me how i can manipulate the above codes to
list only the queries i want to appear in a listbox?
Thanks!

 

[Chris]

Which queries do you want to see?

You could store the names in a table, then use that table
as a rowsource for the list box. Or, you could use a
value list and hard code them.

We need a little more info to provide assistance.


Chris

 

[SeRene]

Hi Chris,

The code which was given to me as shown --> SELECT
MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Name
Not Like "~sq*" AND MSysObjects.Type=5
allows me to view ALL the queries which i have actually
created in my Access Database.

For example, I have 3 queries in my DB, "Query1", "Query2"
and "Query3". I only want to show "Query1" and "Query2" in
my listbox which will be found on a form. How can i
actually do this??