Populate a text box

[fjclaus]

Here goes. I have a text box on my form right now. I also have option buttons to determine were to pull information from. What to do is this.

When the CD option is selected, I want the form to find all the .mdb files on the CD, open them up, and list all the tables in these .mdb files in the text box, and make it a pull down menu.

Now, can anyone help me with the code? Also do I need to change my text box to a pull down menu, or can the code change it for me?

Thank you,