Combobox to select qurey

  • Thread starter Thread starter tfoulkes
  • Start date Start date
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
 
Back
Top