I’ve been working on code to cross-reference data sources, tables or queries, against queries, tables, and forms. And I finally have a workable solution. I will publish it here, but it needs a little cleanup first.
I recently generated such a report and found a surprising number of reports that weren’t using a query for their recordsource, they had SQL statements instead. There’s nothing wrong with that, but all of a sudden I had to use a memo field for the cross-reference, which you can’t sort on.
The biggest offender? A select statement that named 22 fields, complete with the full name of the query, which was upwards of 40 characters long. And after all of those field names? A *. And there’s only the one table for the report.
I don’t know what I was thinking. Shouldn’t be too difficult to clean up.