Automate Combo Box Selection

[Chris Arenburg via AccessMonster.com]

I have a form with a drop down selection. The dropdown contains a list of table names and next to it a button. So the operator would go through and select a table and hit the create table button. And it would create that table. What I would like to provide is an option to have a button that says create all in list. Is this possible? Any ideas on how to execute.

Thanks

--
Message posted via http://www.accessmonster.com

[PC Datasheet]

Write the code to do the following:
Dim MyTable As Table
For each MyTable in List Of tables
DoCmd.OpenQuery "NameOfMakeTableQuery" ' where criteria is MyTable
Next

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Chris Arenburg via AccessMonster.com" <fo***@AccessMonster.com> wrote in
message news:68******************************@AccessMonste r.com...

I have a form with a drop down selection. The dropdown contains a list of table names and next to it a button. So the operator would go through and
select a table and hit the create table button. And it would create that
table. What I would like to provide is an option to have a button that says
create all in list. Is this possible? Any ideas on how to execute.
Thanks

--
Message posted via http://www.accessmonster.com