Need to Create a New Table

[calihiker]

I have a form which contains a list of tables in a combo box, the user clicks on a table name and then clicks on the command button (that opens that particular table)...Here's where I am stuck. I need to create code that takes all the records selected by the user and create a seperate "new" table. Is this possible? What I would like is to enable the user to press a button after they select a group or multiple groups of rows in the table and be able to create a table from scratch. Any help would be appreciated, thanks!

 

[Jooky68]

If i understand what you asking....

dim cell as range

for each cell in range("whatever you range&quot
combobox1.additem cell.value
next cell



you just need to loop through all the cells with in the range. And in the loop add the coding that you need. This just simply adds every cell in the range to the combo box.

hope this helps

Paul J.

 

[calihiker]

Is that ok to use in Access, or is that syntax just for Excel?

 

[Jooky68]

wow...i did this example for an excel application, and I didnt read your post closely enough. You need to do this with access?? Sorry about that, I need more cofee.

Paul J.