Selecting Table From Drop - Down Box

Hi,
I've got a form with a button that runs a query.
This gets all results on a keyword in a table.

I was wondering if there was any way that I can use a drop-down box on this form to select the table I want to run the query on?

Thanks for any help.

Here is two options:

You can have your first drop down list you tables and based on the table selected pass the SQL statement into a RecordSet Control that your second dropdown is based on.
-This is a cleaner options
-This isn't easy for the novice user, but possible

OR

You can have your first grop down list your tables and based on what table you select, make the next combo box (that queries the apporiate table) visible.
-Is easier then the other options
-requires multiple combo box (one for each potential table selection) that all start invisible
-Isn't as clean from a design standpoint (user won't know)

Good Luck
S-