'select into' statement in ADP file

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top