Using a Combobox to pull up Access Tables

[needshelp12]

I have a access file with tables for each month.
Does anyone know how i could code a combo box to display each month in the access file ?

If clicked on to output that months table data into my excel sheet ?


I would really appreciate some help, been waiting all day for someone to answer my last form post, getting a bit discouraged. I know i am a Excel noob, im really trying to learn if someone can offer be some direction.

 

[Joe4]

I find that doing projects between Excel and Access can get unnecessarily messy and complicated (other than maybe having a few Excel lookup tables in an Access database), and if you are not an experienced program in each, it can be difficult to maintain/support.

Can you explain the need for needing some stuff in Excel and some in Access? It might be possible to simplify it and make things a little easier to work with.

 

[Norie]

Do you mean that in Access you want to create a form with a combobox where you can select the table to export to Excel?

That should be pretty straightforward.

All you would need to do is populate the combobox with the table names and
then, via a button perhaps, use DoComd.TransferToSpreadsheet to export the selected table.

Can you give more details?