report/form recordsource prop.

  • Thread starter Thread starter Russ
  • Start date Start date
R

Russ

Sometimes when working with a db I find it necessary to change a query
a bit to narrow it's choices. Only problem is, sometimes I use the
same query for more than one report or form, so when I make a change
in a query to narrow the records chosen for one report, it affects
others negatively. Aside from opening every report/form in design
view and reading it's record souce properties, is there a way to find
out which report/form is being served by each query and visa-versa?

Russ
 
Why not filter a report when you open it? The fourth argument of the
DoCmd.OpenReport method allows you to filter a query's records to a smaller
set than you'd normally see. This is the easiest way to limit a query for
different reports without having to rewrite the query each time.
 
Back
Top