Combo box with list of tables and queries

[Paterson]

I am pretty sure it is possible but i don't know how to do it.

How can I populate a combo box with either all the Table names or all the
Query names. I think i just need to know the right query that does this
because then I could change the Combo Box's rowsource property.

 

[Ofer Cohen]

Look at this link on "Return database object names"

http://www.mvps.org/access/queries/qry0002.htm