Help with MSysObjects problem please..

  • Thread starter Thread starter Simon Radford via AccessMonster.com
  • Start date Start date
S

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 !
 
Simon Radford via AccessMonster.com said:
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
Click to expand...
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
Click to expand...
(((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.
 
Back
Top