Populate a combo box with a list of all queries in the database

[dhstein]

Is there a way to populate a combo box with a list of all the queries in the
database? What about all the queries - except for update and append queries?
Thanks for any help on this.

 

[Tom van Stiphout]

On Mon, 16 Mar 2009 19:01:01 -0700, dhstein

Sure you can. Use a valuelist. Create the string by iterating over the
DAO.Querydefs collection, inspecting the Type property if you want to
exclude certain types of queries.

-Tom.
Microsoft Access MVP

 

[dhstein]

Tom,

Thanks for your reply. I'm a little stuck on how to implement your
suggestion. I know how to get a valuelist into a combobox but I'm not sure
of the syntax and method needed to create the string. Any hint in that
direction would be greatly appreciated.

David