combo box with list of available queries (1 Viewer)

[orconectes]

I have developed a front-end application in Access 2000 in which the user cannot see the main database window. However, I have given the user the capability of importing queries from other databases and a means of running each, given that they type the name correctly into a text box. It would be far better to give them a choice of available queries in case their memory fails them. How can I show the list of available queries in a combo/list box (on a form)? I think it will have something to do with making a function that uses the QueryDefs collection but I keep running into errors with the way I have tried writing the code.

Any suggestions? Thanks in advance.

 

[dennis g]

Are they are importing queries from another database? Can you not create a table with the query names as one field, show them in a list/combo box and run them off the on-click event? If the queries are all in the same database, you can show them in a list box or combo box using the MySysObjects commands. I'm still in Access97, so none of this may be relevant to you.