Combo box problem.

[BobLoblaws]

I would like a combo box that dynamically gets items when the form is loaded. However, I want it to list all the reports in the database.
Thing is, there is no additem functionality.
Is there something I'm missing?

Thanks.

 

[GGleason]

On the combo box properties, under the data tab, in the Row Source line, put the following syntax:

SELECT MSysObjects.Name FROM MSysObjects WHERE Type =-32764 ORDER BY Name;


HTH,
GGleason

 

[BobLoblaws]

Thank you. It works great.