Query Combo Box Table Question

[Igawa29]

OK so basically what I am looking to do is to have a drop down (Combo Box) with all my tables listed. I want to have a query basically pull all the table's data depending on which table the user selects.

I just wanted to see why this code doesn't work and if anyone had suggestions.

SELECT *
FROM [FORMS]![Report]![Report];

 

[PWise]

"SELECT *
FROM " & [FORMS]![Report]![Report];

i dont know from where you running this code but it will be something like the above

 

[Igawa29]

hmm.

I am getting an error "Invalid SQL statement; expected 'DELETE','INSERT','PROCEDURE','SELECT', or 'UPDATE'.

 

[PWise]

from where are you running this code

 

[Igawa29]

I am just creating a blank Query using SQL. Not bringing any tables in or anything.

 

[PWise]

i do not think that you can do this from a blank query

what you can do is create a query and put in any table name

and in code on the form

dim mydb as database 
set mydb = currentdb
mydb.querydefs("queryname").sql="SELECT * FROM " & me.report
docmd.openquery "queryname"