List Box Thing!!!

[TheOx2K]

Hi All

Can i have a combo box with the values of table, queries, forms, pages, macros and moduals and when one of these values is selected a listbox or something that will show me all the table, qeries etc??

Evan better can i get an open dialog box to appear, the reason i want this is so that users of my db can send files as attachments of e-mails.

Any surgestions would be appreciated.

 

[llkhoutx]

The names are object names are available from their respective container using DAO code.

 

[TheOx2K]

Thanks for the reply. Any help is appreciated but what does that mean in English, im rather new to Access & VBA.