Combobox to select qurey

[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