T
tim
In my project I create an SQL 'select into' statement on the fly, using potentially a different tablename to be created every time. I want to use the resulting table as the source object for a subform. The problem is that the table, once created, does not appear in the list of tables. When I open the subsequent form in which it is to be displayed, the message says "cannot find [tablename]". However the table really is there, and when I go to Tools -> Options and tick "view hidden objects" it suddenly appears in the list even though it is not a hidden object. (When I go back into Tools -> Options and remove the tick from "view hidden objects" the table continues to appear in the list .)
Any ideas?
Any ideas?