Query with parameter?

[RJN]

I have a form that has two dropdown lists. First ddl specifies table to work with. Second ddl is populated dependant upon the table that has been selected in the first ddl.

I know how to specify form elements inside a query, however this first ddl is selecting the table that I want to pull a query from. When I right click the TABLE field under query design I am not prompted with the Build option as usual. (Note: The query will be identical regardless of the table that has been selected)

Is there a way with the [] brackets to specify the table to use in the following ddls query or should I use a parameter somehow?

Thanks,

 

[pbaldy]

No, you will need to build the query in VBA to get what you're after. This type of question always prompts the question of "why", as in why do you need to select the table? It often uncovers a design mistake, like tables for each year or something along those lines.