HOW TO CHOOSE A TABLE WITH VBA

[Guest_imported]

Does anyone know how to select a table based on a string. i nned to choose the table based on the combobox selection.


thanks

 

[JoeMiller]

Can you explain what you are trying to do a little more? I'm not following the question, examples are helpful! Joe Miller
joe.miller@flotech.net

 

[Guest_imported]

i am trying to use a combo box to choose a table. i have 4 combo boxs which select criteria and need to create a sql string that will translate into sql such as:

strsql ="select s_account,s_mtdact,S_mtdbud from s_month;"


s_month can be any of 12 tables for each month. when a person picks the month from the drop down, i need it to refer to the table i need to query on.

thanks


mark

 

[JoeMiller]

Something like this perhaps?

strSQL = strsql ="select s_account,s_mtdact,S_mtdbud from " & MonthComboName &";"

HTH Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

Let's try that again:

strSQL = "select s_account,s_mtdact,S_mtdbud from " & MonthComboName &";"
Joe Miller
joe.miller@flotech.net