J
JonWayn
I have a bunch of reports in an Access97 database. I wrote a VBA procedure
which opens each report in design view and documents some report properties.
Some of the reports are based on tables and others on queries. In either
event, how do I get the Filter property? Using the Filter property of a
recordset based on the underlying tabledef or querydef returns "" whether a
filter is set or not. For the tables, the filter is set from the
Records/Advance Filter-Sort menu
which opens each report in design view and documents some report properties.
Some of the reports are based on tables and others on queries. In either
event, how do I get the Filter property? Using the Filter property of a
recordset based on the underlying tabledef or querydef returns "" whether a
filter is set or not. For the tables, the filter is set from the
Records/Advance Filter-Sort menu