Can't find subreports/queries

C

C Tate

I work with a large database. Sometimes I look at the record source of a
report. It will often say it appears to be based on some other subreport or
query. Very often I can't find that other subreport or query when I scroll
through the lists.

What is the best way to ensure that a query/subform is definitely there?
Alternatively how do I ensure that my form is not looking for some query
which has now been deleted? Obviously you would think that if the query had
been deleted then the report wouldn't run. In my case all the reports do run
but I can't always find the queries!!
 
G

GVaught

Keep in mind that a report can be linked through a SQL statement in
Recordsource Properties. If you open a report/subreport in design view and
take a look at the Record source part, click on the ... (ellipses), you
will invoke the SQL Builder. This will allow you to base a report against a
SQL created query. This query is not saved external to the report, but
internally. Check to see if you have this scenario on your subreports.
 
C

C Tate

Many thanks. I think this must be the case with the database I am working
with. Unfortunately I don't know any sql.
 
D

Doug Munich

They could be hidden. Look under menu Tools-Options, View tab, Hidden items
checkbox.

Doug
 
Top