List of Queries 1

[Ajwebb]

Hi All,

I was wondering if it possible to populating a combo box with the names of my queries?

The user would then be able to select the query they want from the drop down.

If it is possible would there be any way of automating it so if a new query was added it would automatically appear in the combo box.

Thanks in Advance

Anthony

 

[KenReay]

Hi

Try

SELECT Name FROM mSysObjects WHERE Type = 5; as your rowsource in a combo



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ajwebb]

Thanks Ken,

Was thinking i had to type them all in manually.

Regards

Anthony