From: Mark on
Hi All,

I'm trying to make a form that shows a list of queries presently in my
database. How do I go about creating a list from queries that reside in my
db?

From: fredg on
On Fri, 4 Dec 2009 14:01:01 -0800, Mark wrote:

> Hi All,
>
> I'm trying to make a form that shows a list of queries presently in my
> database. How do I go about creating a list from queries that reside in my
> db?

To show all the named queries in the current database, add a listbox
control to your form.
As ListBox rowsource:

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((Left([Name],1))<>"~") AND ((MSysObjects.Type)=5))
ORDER BY MSysObjects.Name;

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail