Dropdown list to open queries

S

SiH23

I would be most grateful is someone could offer some help or advice.

Is it possible to have a droplist containing queries, whereby when one is
selected the query is automatically run and displayted on screen. Any help or
advice would be greatly appreciated.

If this is possible a 'step by step' guide would be most appreciated.

Many thanks in advance.

Simon.
 
A

Allen Browne

Put this in the Row Source property of your combo to get a list of queries:
SELECT MSysObjects.Name FROM MsysObjects
WHERE ((MSysObjects.Type = 5) AND ([Name] Not Like "~*"))
ORDER BY MSysObjects.Name;

You can then use the AfterUpdate event of the combo to OpenQuery.
 
Top