Help with MSysObjects problem please..

[Simon Radford via AccessMonster.com]

I have a form which contains a field that collects the MSysObjects list of queries within the system.

Also on this form there is a button that is told to apply the query chosen by the user to a certain second form, however I cant seem to tell the button to select the object.

Currently I have:

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Name)=Me![Choose Filter]))

Anyone help please !

 

[margaret bartley]

I have a form which contains a field that collects the MSysObjects list of queries within the system.

Also on this form there is a button that is told to apply the query chosen

by the user to a certain second form, however I cant seem to tell the button
to select the object.

Currently I have:

SELECT MSysObjects.Name FROM MSysObjects WHERE

(((MSysObjects.Name)=Me![Choose Filter]))

You have to make sure that the bound column on [Choose Filter] is name.
That is not likely, since different objects can have the same name.
You probably have to either filter for just queries, or else use object id
as the bound column for your list.

try writing this as a query, and use literals instead of variables, until
you make sure you're linking up all the correct fields.