listbox/combobox list alltables

[tdubs]

Hi guys

Just wondering how could a make a listbox or combobox to have the names of all or some of the tables that are currently in my database

I only know how to get the values from a table or query in RowSource using SQL language... but how can I display the names of the tables

Thanks in advance for the help.. I really appreciate it

 

[Banana]

I don't see why you need to list multiple tables in a single listbox, but if you really insist, you can create a query and have two tables in the query, then have listbox recordsource use that query. No coding necessary.

But still, I'd think hard about whether I really want more than one table in single listbox.

 

[WayneRyan]

td,

You can base the listbox a query of the MsysObjects table.

It will have the names of all your tables.

Wayne

 

[tdubs]

td,

You can base the listbox a query of the MsysObjects table.

It will have the names of all your tables.

Wayne

IC. What I did was making a Value list for the Combo Box

mmm for you method.. I tried using it..
In Rowsource type i put Query/table
in Rowsource i put MsysObjects

But when I expanded my combobox, There seems to be something there but it was all blank.

But anyhow Thanks for the Help

 

[Banana]

Did you actually create the query for MsysObjects before you put it in the rowsource?