query record source

[hotrod1952 via AccessMonster.com]

My database has 15 tables with the same structure. Each table holds the
values for a recipe. From my form I have a combobox to choose tablex. What I
want to do is from a command button on the form create a select query and use
the combobox value as the source for the table I want the records pulled from.
I ceated a select query for 1 table. Used that code as a string using the
combo value as a variable in the string to show the table source but that
error was 2342. And after reading I find out RunSql is for action type querys.
Any Ideas?

 

[KARL DEWEY]

Use only one table with added field to identify the recipe.