Combobox to select qurey

T

tfoulkes

Hi all,

I'm wanting to use a combobox to select a query from the queries whic
are available.

After this I'm going to pass it as a variable on a form for a selec
statement. This bit I'm fine with, It's just getting the dropdown o
all available queries.

Thankyou!

Ti
 
?

___

If you have prefixed your queries with qry then place this in combo'
RowSource:

SELECT Mid(Name,4) AS MyQueries FROM MSysObjects
WHERE Left(Name, 3) = "qry" ORDER BY Mid(Name,4);

HT
 
Top