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
 
Ad

Advertisements

?

___

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top