report/form recordsource prop.

[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

 

[Ken Snell]

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.