Drop Down Box, need help please

[ryanc75ca]

What I am trying to do is create a form that is basically a title page, and it will have a drop down box that lets someone look through my tables and pick which one they want to see. I am fairly new to Access and have no instruction book here at work so bare with me please. Is this possible?

Thanks in advance

 

[Mile-O]

Double Post

 

[Tay]

I guess the easiest thing for you to do is to create a new table which just contains all of the table names you want to appear, then simply create a form based on this new table, put a combo box on it with the record source as the field name for the table names. Hope I haven't lost you...
The good thing is that you can decide which tables users see, but the bad thing is that you have to update it whenever you add new tables.

 

[Mile-O]

Tools -> Options

You can check the box to Show System Objects (and the hidden ones.

One of the System Objects is a table called MSysObjects. This contains your tables, queries, etc..

You can query this table to give you a list of all your tables.