msysobjects question

[mavver]

Good Afternoon Everyone

I am trying to get a list box on a form to show the name of the reports within the database, and after several days trolling forums I came across the msysobjects approach.

I am typing the following in word for word in the ROW SOURCE of an unbound list box on the form.

SELECT [Name] FROM MsysObjects WHERE (([Type] = -32764) AND ([Name] Not Like "~*") AND ([Name] Not Like "MSys*")) ORDER BY [Name];

The ROW SOURCE TYPE is set at VALUE LIST

When I do this the names of the reports are not brought back, all that is in the first line of the list box is what I type above.

I think that my problem comes from the [Name] section, as I am unsure whether I need a specific Name in here or to leave it as [Name]

Any help will be very gratefully recieved.

Best Regards and Thanks in Advance

Mav

 

[missinglinq]

Have no idea how to accomplish your goal, but setting the ROW SOURCE TYPE to VALUE LIST means that you have typed in the literal values for the list box, which you have not done! Try setting the Row Source Type to Table/Query.