Dropdown list to open queries

  • Thread starter Thread starter SiH23
  • Start date Start date
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.
 
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.
 

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

Similar Threads

Using Option Buttons 1
Mathematical Calculations 2
Date search query 0
Simple AND query 2
dropdown from table or query 2
Update query 2
List To: 4
how to pass a parameter to a query base of a query that is the base of a report 0

Back
Top