Running an SQL statement with combobox values (1 Viewer)

[bobbybeers]

Hello all
I have a form that has a combobox with table names in it. I want to execute a very complicated SQL statement but I want to put the table name (from the combobox) into the SQL statement. I'm planning on making a button to do this, but I don't know how to put the SQL statement in VBS which would use the combobox value as the table name in the SQL statement. Anyone ever done anything like this before??

Thanks

 

[pr2-eugin]

I have done something similar.. Where you stuck at? What is that you are trying to achieve? More information would help us to address the problem precisely..

 

[bobbybeers]

well i've built the query and saved it as a query (with an existing table). Now, I want to copy and paste that sql language as part of a button on a form, except, I will take and replace the table name in the SQL with a value from a combobox on my form.....I just don't know how to write the language to do that. When I push the button, I want the button to run the SQL statement with the combobox value plugged in.....does that make sense??