A Query List of Queries How can I use it?

[armstrong722]

I have made a query of the objects in the database using (msysobjects) and have narrowed them down to a select group of query names. These queries have the list I want to loop through.
Access won't allow me to use the query of queries for input into a combo box.

anyway around this?

 

[smedvid]

How bout QueryDef? That is what I use... Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[Quehay]

I do this same thing. Just create the query with Msysobjects (I think that's the table). Having a prefix helps to restrict your output to queries, e.g., LIKE 'qry*'.

You can then run with a command button:

strQuery = me.cboName

DoCmd.OpenQuery strQuery

But you said loop...

Dim Qdf as DAO.QueryDef

For Each Qdf in CurrentDB.QueryDefs

'Code

Next

If this hasn't addressed the question post again!